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.
Field Name | Type | Description |
---|---|---|
APPLID | CHAR(8) | CICS region applid. |
HOMESYSID | CHAR(4) | SYSID of local region. |
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:
|
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. |