Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 3 Mbox Sets and Message Queues : iql_queues

iql_queues
The iql_queues table defines each message queue that is available on this iProcess Engine node.
Structure
The iql_queues table has the following structure:
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)
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 QueueID
The 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:[instance]:queue_table:queue
where:
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.
For example, the entry:

 
0001::bgmboxtable1:bgmboxqueue1

 
describes the AQ queue called bgmboxqueue1 contained in queue table bgmboxtable1 on the default Oracle instance.
Default Message Queues and AQ Tables
When 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.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Storage
The following STORAGE values are defined for this table.
Table Activity
The iql_queues table contains one row for each message queue that is available on this node.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.