Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 18 WQS/WIS Shared Memory : wqs_index

wqs_index
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.
Structure
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.
0, otherwise.
1, if the queue is currently redirected.
0, otherwise.
1, if the queue is currently disabled.
0, otherwise.
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 wqs_index table contains one row for each work queue on the system that is handled by a WIS process.
Rows are added, updated and deleted in the following situations.
Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator’s Guide for more information about the WQS_PERSIST_SHMEM process attribute.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved