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.
Start of change APPL_NAME End of change Start of change CHAR(64) End of change Start of change Application name End of change
Start of change APPL_VER1 End of change Start of change INTEGER End of change Start of change Major version number End of change
Start of change APPL_VER2 End of change Start of change INTEGER End of change Start of change Minor version number End of change
Start of change APPL_VER3 End of change Start of change INTEGER End of change Start of change Micro version number End of change
Start of change APPL_OPER End of change Start of change CHAR(64) End of change Start of change The operation associated with the task End of change
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.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 22 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///db2t5.html