Transient Data queue resource table

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

CIU_TDQUEUE_DETAIL
This table stores detailed information about every CICS® transient data queue referenced in a transaction recorded by the Collector. Transient data queue information is stored in this table only if the TD Queues field on the CICS Resources Options panel, CIU240, is set to D.
Table 1. The CIU_TDQUEUE_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
TDQUEUE_NAME CHAR(4) The name of the transient data queue definition.
ATIFACILITY CHAR(10) Indicates whether the queue has a terminal or session associated with it. Values are: NOTAPPLIC, NOTERMINAL, and TERMINAL
ATITERMID CHAR(4) The name of the terminal or session associated with the queue.
ATITRANID CHAR(4) Identifies the transaction to be run when CICS initiates a task automatically to process the queue.
ATIUSER CHAR(8) The user identifier associated with the queue.
BLOCKFORMAT CHAR(10) Indicates whether the data set associated with the queue is in blocked record format or not. Values are: BLOCKED, UNBLOCKED, and NOTAPPLIC.
BLOCKSIZE INTEGER The length of the block in bytes.
DATABUFFERS INTEGER The number of buffers to be used by this queue.
DDNAME CHAR(8) An identifier that refers to an associated data set name.
DISPOSITION CHAR(10) Indicates the status of the associated data set. Values are: MOD, OLD, SHARE, and NOTAPPLIC.
DSNAME CHAR(44) The name of the associated QSAM data set.
ERROROPTION CHAR(8) Indicates the action CICS takes if an I/O error is encountered. Values are:
IGNORERR
The block that caused the error is accepted.
SKIP
The block that caused the error is skipped.
INDIRECTNAME CHAR(4) The name of the queue to which this indirect queue points.
INDOUBT CHAR(8) Indicates the action that CICS takes for an indoubt unit of work, if the definition for this queue specifies WAIT(YES). Values are: QUEUE and REJECT.
INDOUBTWAIT CHAR(8) Indicates whether an indoubt unit of work will wait for resynchronization with its coordinator to determine whether to commit or back out the changes. Values are: NOWAIT and WAIT.
IOTYPE CHAR(10) Indicates whether the queue is defined for input or output. Values are: INPUT, OUTPUT, RDBACK, or NOTAPPLIC.
MEMBER CHAR(8) Member name if the queue is a member of a partitioned data set.
PRINTCONTROL CHAR(10) Indicates the type of print control, if any, defined for the queue. Values are: ASACTL, MCHCTL, NOCTL, and NOTAPPLIC.
RECORDFORMAT CHAR(10) Indicates whether the queue has fixed-length or variable-length records. Values are: FIXED VARIABLE, and NOTAPPLIC.
RECORDLENGTH INTEGER The record length, in bytes, for queues having fixed-length records, or the maximum record length of queues having variable-length records. Applies only to extrapartition queues; for others, -1 is present.
RECOVSTATUS CHAR(12) Indicates the type of recovery defined for the queue. Recovery is available only for intrapartition queues. Values are: LOGICAL, PHYSICAL, NOTRECOVABLE, and NOTAPPLIC.
REMOTENAME CHAR(4) The name of the queue in the remote CICS region in which the queue is defined. Applies only to queues defined as remote, for other queues the value is blanks.
REMOTESYSTEM CHAR(4) The name of the CICS region in which the queue is defined. Applies only to queues defined as remote; for other queues the value is blanks.
REWIND CHAR(8) Indicates the disposition of a tape data set. Values are: LEAVE and REREAD.
SYSOUTCLASS CHAR(1) Indicates the class attribute of the associated SYSOUT data set, or blank if DSNAME is used.
TRIGGERLEVEL INTEGER The number of items the queue must contain before automatic transaction initiation (ATI) occurs. A value of zero means the queue is not subject to ATI. A value of -1 means the queue is not intrapartition.
TYPE CHAR(8) Identifies the type of queue. Values are: EXTRA, INDIRECT, INTRA, and REMOTE.
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///db2t4.html