![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
TABLE iql_tables (
queue_id number(5) NOT NULL,
queue_name varchar2(24) NOT NULL,
queue_type number(2) NOT NULL,
queue_phys_descr varchar2(100) NOT NULL)
Message type used by this message queue. This value is always 1, for local messages. ID of the Oracle AQ queue that is used to hold this message queue. See:Format of the Oracle AQ QueueID for a description of the format used for this value.Oracle AQ Queue Tables and Queues for more information about the required structure of AQ queue tables and queues, and how to create them.Format of the Oracle AQ QueueIDThe ID of the Oracle AQ queue that is used to hold this message queue (in the queue_phys_descr column) is specified using the following format:
• 0001 indicates that the remainder of the string uses Oracle AQ format.
• instance is the Oracle Service Name of the Oracle instance that holds the AQ queue. If this is blank, the default local instance is assumed.
• queue_table is the name of the AQ queue table that holds the AQ queue.
• queue is the name of the AQ queue used to hold this message queue.
describes the AQ queue called bgmboxqueue1 contained in queue table bgmboxtable1 on the default Oracle instance.Default Message Queues and AQ TablesWhen the iProcess Engine is installed, the init2Kora.sql (on UNIX, or on Windows init2Kora_tok.sql) script creates the following default set of message queues and AQ queue tables required by the system.
a new message queue is added to the node, either at installation or by using the SWDIR\util\swadm utility.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |