The wqs_index table holds the information about each work queue on the system that is stored in shared memory by the WQS/WIS processes.
The wqs_index table has the following structure:
TABLE wqs_index(
logical_machine_id number(5) NOT NULL,
logical_process_instance number(5) NOT NULL,
queue_name varchar(24) NOT NULL,
total_items number(20) NULL,
last_cache_time number(20) NULL,
new_items number(20) NULL,
deadline_items number(20) NULL,
urgent_items number(20) NULL,
redir_queue_name varchar(24) NULL,
is_cached number(1) NOT NULL,
is_group number(1) NOT NULL,
is_test number(1) NOT NULL,
is_redirected number(1) NOT NULL,
is_disabled number(1) NOT NULL)
|
|
|
|
|
|
|
|
|
Note: When the iProcess Engine starts up the WIS processes use this value to determine whether or not each work queue should be cached. See "Configuring When WIS Processes Cache Their Queues" in TIBCO iProcess Engine Administrator’s Guide for more information.
|
|
•
|
-1, if the work queue has not yet been cached.
|
|
|
|
|
|
|
|
|
|
|
•
|
1, if the queue is cached.
|
•
|
0, if the queue is not cached.
|
|
|
•
|
1, if the queue is a Group queue.
|
•
|
0, if the queue is a User queue.
|
|
|
•
|
1, if the queue is a Test queue.
|
|
|
•
|
1, if the queue is currently redirected.
|
|
|
•
|
1, if the queue is currently disabled.
|
|
The wqs_index table contains one row for each work queue on the system that is handled by a WIS process.