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


Chapter 3 Mbox Sets and Message Queues : Default SQL Database Queue Tables (Test)

Default SQL Database Queue Tables (Test)
Each message queue defined in the iql_queues table must be mapped to its own SQL database queue table.
When the iProcess Engine is installed, the init2Ksql.sql script creates the default set of queue tables required by the system (see Default Message Queues and SQL Database Queue Tables).
This section describes the format of each of the default queue tables.
If you subsequently decide to add additional message queues to your system, you must manually create the queue tables needed by those message queues. See Creating Additional SQL Database Queue Tables for more information about how to do this.
sw_db_bgqueue_n
Each sw_db_bgqueue_n (where n is 1 or 2) queue table holds messages intended for the background processes:
Structure
The sw_db_bgqueue_n table has the following structure:
TABLE sw_db_bgqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried.
When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
 
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.
Primary Key
No primary key is defined for this table.
Triggers
None.
Indexes
The following clustered index is defined for this table.
Table Activity
Each sw_db_bgqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.
sw_db_wisqueue_n
Each sw_db_wisqueue_n (where n is 1 or 2) queue table holds messages intended for the Work Item Server Mbox daemon process:
Structure
The sw_db_wisqueue_n table has the following structure:
TABLE sw_db_wisqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
 
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried.
When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.
Primary Key
No primary key is defined for this table.
Triggers
None.
Indexes
The following clustered index is defined for this table.
Table Activity
Each sw_db_wisqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
the WISMBD process dequeues a message from this table and either:
cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.
sw_db_predictqueue_n
Each sw_db_predictqueue_n (where n is 1 or 2) queue table holds messages intended for the background case prediction server processes:
Structure
The sw_db_predictqueue_n table has the following structure:
TABLE sw_db_predictqueue_n (
rowid NUMERIC(15) identity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
 
When this value equals or exceeds the value of the IQL_RETRY_DELAY process attribute, the message is retried.
When this value equals or exceeds the value of the IQL_RETRY_COUNT process attribute, the message is moved to the sw_db_deadqueue.
See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for more information about the IQL_RETRY_DELAY and IQL_RETRY_COUNT attributes.
Primary Key
No primary key is defined for this table.
Triggers
None.
Indexes
The following clustered index is defined for this table.
Table Activity
Each sw_db_predictqueue_n table contains one row for each enqueued message. Rows are added, updated and deleted in the following situations.
cannot successfully process it, and moves it to the sw_db_deadqueue table because it has exceeded the IQL_RETRY_COUNT value.
sw_db_deadqueue
The sw_db_deadqueue table holds failed messages from the sw_db_bgqueue_n, sw_db_wisqueue_n and sw_db_predictqueue_n tables.
Structure
The sw_db_deadqueue table has the following structure:
TABLE sw_db_deadqueue (
failed_by varchar(64) NOT NULL
rowid NUMERIC(15) iden tity(1,1),
last_failed NUMERIC(10) NULL,
failure_count INTEGER NOT NULL,
msg_id uniqueidentifier NOT NULL,
msg_hdr VARCHAR(512) NULL,
msg_data VARCHAR(1024) NOT NULL
priority INTEGER NOT NULL)
 
Note: Messages in this table are not retried.
Primary Key
No primary key is defined for this table.
Triggers
None.
Indexes
The following clustered index is defined for this table.
Table Activity
The sw_db_deadqueue table contains one row for each message that has exceeded its IQL_RETRY_COUNT threshold value.
Rows are added, updated and deleted in the following situations.
a message is moved to this table from a sw_db_bgqueue_n, sw_db_wisqueue_n or sw_db_predictqueue_n table, because it has exceeded the IQL_RETRY_COUNT value.

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