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.
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. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
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:
|
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. |