Copyright © Cloud Software Group, Inc. All Rights Reserved

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 INTEGER NOT NULL,
logical_process_instance INTEGER NOT NULL,
queue_name VARCHAR(24) NOT NULL,
total_items NUMERIC(20) NULL,
last_cache_time NUMERIC(20) NULL,
new_items NUMERIC(20) NULL,
deadline_items NUMERIC(20) NULL,
urgent_items NUMERIC(20) NULL,
redir_queue_name VARCHAR(24) NULL,
is_cached SMALLINT NOT NULL,
is_group SMALLINT NOT NULL,
is_test SMALLINT NOT NULL,
is_redirected SMALLINT NOT NULL,
is_disabled SMALLINT NOT NULL)

Column Name	Description
logical_machine_id	ID of the server where the WIS process that is handling this work queue is running, as defined in the node_cluster table.
logical_process_instance	ID of the instance of the WIS process that is handling this work queue, as defined in the process_config table.
queue_name	Name of the work queue.
total_items	Total number of items in this work queue. 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.
last_cache_time	Either: • Time taken to cache the work queue (in milliseconds) when it was last cached, either when the WIS process first started up or when the work queue was first accessed. • -1, if the work queue has not yet been cached.
new_items	Number of new, unopened items in this work queue.
deadline_items	Number of items in this work queue that have deadlines.
urgent_items	Number of items in this work queue that have an urgent priority.
redir_queue_name	Either: • the name of the work queue that this queue is currently being redirected to, if the queue is currently being redirected (is_redirected = 1). • empty, if the queue is currently not being redirected (is_redirected = 0).
is_cached	Indicates whether the queue is currently cached by the WIS process. Either: • 1, if the queue is cached. • 0, if the queue is not cached.
is_group	Indicates whether the queue is a Group queue. Either: • 1, if the queue is a Group queue. • 0, if the queue is a User queue.
is_test	Indicates whether the queue is a Test queue. Either: • 1, if the queue is a Test queue. • 0, otherwise.
is_redirected	Indicates whether the queue is currently being redirected to redir_queue_name. Either: • 1, if the queue is currently redirected. • 0, otherwise.
is_disabled	Indicates whether the queue is disabled. Either: • 1, if the queue is currently disabled. • 0, otherwise.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_wqs_index	queue_name is_test

Foreign Keys

None

Indexes

None

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.

A row is...	When...
added	a new work queue is allocated to a WIS process by the WQS process.
updated	• an existing work queue is re-allocated to a different WIS process by the WQS process. • a MOVESYSINFO has been processed by the WQS process. • the update thread in the WQS process writes the contents of the WQS/WIS shared memory to the database. This update occurs every WQS_PERSIST_SHMEM seconds. Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator’s Guide for more information about the WQS_PERSIST_SHMEM process attribute.
deleted	a WIS is started as the first time the WIS persists the current shared memory to the database it clears out all existing rows and then writes the shared memory to the database table.

Copyright © Cloud Software Group, Inc. All Rights Reserved