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 changeAPPL_NAMEEnd of change Start of changeCHAR(64)End of change Start of changeApplication nameEnd of change
Start of changeAPPL_VER1End of change Start of changeINTEGEREnd of change Start of changeMajor version numberEnd of change
Start of changeAPPL_VER2End of change Start of changeINTEGEREnd of change Start of changeMinor version numberEnd of change
Start of changeAPPL_VER3End of change Start of changeINTEGEREnd of change Start of changeMicro version numberEnd of change
Start of changeAPPL_OPEREnd of change Start of changeCHAR(64)End of change Start of changeThe operation associated with the taskEnd 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, 8 February 2013


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