Temporary Storage queue resource table

Use the information in the CIU_TSQUEUE_DETAIL table to write your own SQL applications to query the tables; these applications must use native SQL queries.

CIU_TSQUEUE_DETAIL
This table stores detailed information about every CICS® temporary storage queue referenced in a transaction recorded by the Collector. TS Queue information is stored in this table only if the TS Queues field on the CICS Resources Options panel, CIU240, is set to D.
Table 1. The CIU_TSQUEUE_DETAIL table
Field Name Type Description
APPLID CHAR(8) CICS region applid.
HOMESYSID CHAR(4) SYSID of local region.
TSQUEUE_NAME CHAR(16) Name of the temporary storage queue.
FLENGTH INTEGER The total length in bytes of all items in the temporary storage queue.
LOCATION CHAR(10) Indicates where the temporary storage queue resides. Values are:
AUXILIARY
The queue is held in CICS temporary storage VSAM data sets.
MAIN
The queue is held in main storage.
MAXITEMLEN INTEGER The length in bytes of the largest item in the queue.
MINITEMLEN INTEGER The length in bytes of the smallest item in the queue.
POOLNAME CHAR(8) The name of a temporary storage pool. CICS ships the command to the temporary storage server that manages the pool.
RECOVSTATUS CHAR(14) Indicates the recovery status of the queue. Values are: RECOVERABLE and NOTRECOVERABLE.
SYSID CHAR(8) The system name that corresponds to a temporary storage pool name.
TRANSID CHAR(4) Identifies the transaction that created the temporary storage queue.
FIRST_RUN TIMESTAMP Time of first occurrence, in the local time format.
LAST_RUN TIMESTAMP Time of latest observation, in the local time format.