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 INTEGER NOT NULL,
queue_name VARCHAR(24) NOT NULL,
queue_type SMALLINT NOT NULL,
queue_phys_descr VARCHAR(100) NOT NULL)
Format of the SQL Database Queue Table ID for a description of the format used for this value.
Default SQL Database Queue Tables (Test) for more information about the default SQL database queue tables, and how to create additional tables.
Format of the SQL Database Queue Table ID
The ID of the SQL database table that is used to hold this message queue (in the queue_phys_descr column) is specified using the following format:
0003:[database_name.][owner.] queue_table
where:
0003 indicates that the remainder of the string uses SQL Server format.
database_name is the name of the database that holds this queue_table. If this option is omitted, the iProcess database is used by default.
If you specify a different database, it must reside on the same SQL Server as the iProcess database.
owner is the username of the user that owns this queue_table. If this option is omitted, the iProcess background user owns the table by default.
queue_table is the name of the SQL database table used to hold this message queue. Each individual queue must be held in its own database table.
For example, the entry:
0003:sw_db_bgqueue_1
describes the SQL database table called sw_db_bgqueue_1, which is stored in the default iProcess database and owned by the iProcess background user.
The entry:
0003:sw.swpro1.sw_db_bgqueue_3
describes the SQL database table called sw_db_bgqueue_3, which is stored in the sw database (on the SQL Server hosting the iProcess database) and owned by user swpro1.
Default Message Queues and SQL Database Queue Tables
When the iProcess Engine is installed, the init2Ksql.sql script creates the following default set of message queues and SQL database queue tables required by the system.
See Default SQL Database Queue Tables (Test) for a detailed description of these tables.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
None.
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