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 COLLECTION_ID CHAR(16) Collection ID. ARCHIVE_DATE TIMESTAMP Time of archiving. APPLID CHAR(8) CICS region applid. HOMESYSID CHAR(4) SYSID of local region. PLATFORM CHAR(64) Platform name APPL_NAME CHAR(64) Application name APPL_VER1 INTEGER Major version number APPL_VER2 INTEGER Minor version number APPL_VER3 INTEGER Micro version number APPL_OPER CHAR(64) The operation associated with the task 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.