Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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)

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` | Indicates the following status if a work queue is being redirected:
| • | 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 and displays the following values:
| • | `1`, if the queue is cached.
| • | `0`, if the queue is not cached.
`is_group` | Indicates whether the queue is a Group queue and displays the following values:
| • | `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 and displays the following values :
| • | `1`, if the queue is a Test queue.
| • | `0`, otherwise.
`is_redirected` | Indicates whether the queue is currently being redirected to `redir_queue_name` and displays the following values:
| • | `1`, if the queue is currently redirected.
| • | `0`, otherwise.
`is_disabled` | Indicates whether the queue is disabled and displays the following values :
| • | `1`, if the queue is currently disabled.
| • | `0`, otherwise.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_wqs_index` | `queue_name is_test` | MEDIUMINDEXSPACE

## Foreign Keys

None

## Indexes

None

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | MEDIUMTABLESIZE
Percentage Increase | MEDIUMTABLEPCTINCREASE
Tablespace | MEDIUMTABLESPACE

## 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.
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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine