Use the information in the CIU_TRANSID_DETAIL tables 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 |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
TRANSID | CHAR(4) | The name of the transaction definition. |
BREXIT | CHAR(8) | The name of the bridge exit defined by the BREXIT parameter of the named transaction definition. |
CMDSEC | CHAR(1) | Indicates whether command security checking
will be performed for the tasks running the transaction. Values are:
|
DTIMEOUT | INTEGER | The deadlock time-out value in seconds for the task running this transaction. |
DUMP | CHAR(1) | Indicates whether the transaction is defined
for dumping. Values are:
|
DYNAMIC | CHAR(1) | Indicates whether the transaction is defined
for dynamic transaction routing. Values are:
|
INDOUBT | CHAR(8) | The action CICS takes if the CICS region fails or loses connectivity with its coordinator while a unit of work is in the indoubt period. |
INDOUBT_WAIT | CHAR(1) | The response that the CICS unit of work takes if a failure occurs
while in an indoubt state. Values are:
|
INDOUBT_WAIT_TIME | INTEGER | The length of time, in minutes, after a failure during the indoubt period, before the transaction takes the action returned in the INDOUBT field. |
INITIAL_PROGRAM | CHAR(8) | The name of the initial program given control for the transaction. |
ISOLATE | CHAR(1) | Indicated whether transaction isolation is required
for the transaction task-lifetime user-key storage. Values are:
|
LOCAL_QUEUING | CHAR(1) | Indicates whether the started request for this
transaction is eligible to be queued locally if the transaction is
to be started on another system and the remote system is not available.
Values are:
|
OTSTIMEOUT | INTEGER | The period of time, in seconds, that an Object Transaction Service (OTS) transaction is allowed to run without the initiator of the OTS transaction taking a sync point (or rolling back the OTS transaction). |
PARTITIONSET | CHAR(8) | Indicates the partition set specified on the transaction definition. Values are: KEEP, NAMED, OWN, and NONE. |
PARTITIONSET_NAME | CHAR(8) | The partition set defined on the transaction definition. |
PROFILE_NAME | CHAR(8) | The profile definition associated with the transaction definition. |
REMOTE | CHAR(1) | Indicates whether the transaction is defined
as remote. Values are:
|
REMOTE_NAME | CHAR(8) | The remote name as specified on the transaction definition. |
REMOTE_SYSTEM | CHAR(4) | The remote system as specified on the transaction definition. |
RESSEC | CHAR(1) | Indicates whether resource security checking
is required for the transaction. Values are:
|
RESTART | CHAR(1) | Indicates whether the transaction is considered
for transaction restart. Values are:
|
ROUTABLE_STATUS | CHAR(12) | Indicates whether the transaction, from a START command, is routed using the enhanced routing method. Values are: ROUTABLE and NOTROUTABLE. |
RUNAWAY_LIMIT | INTEGER | The runaway-task time limit specified on the transaction definition. |
SHUTDOWN | CHAR(8) | Indicates whether the transaction can be run during CICS shutdown. Values are: ENABLED and DISABLED. |
SPURGE | CHAR(1) | Indicates whether the transaction is defined
as system-purgeable. Values are:
|
STORAGE_CLEAR | CHAR(1) | Indicates whether task-lifetime storage is cleared
before it is freed by a FREEMAIN command. Values are:
|
STORAGE_FREEZE | CHAR(1) | Indicates whether the storage freeze option
is defined for the transaction. Values are:
|
SYSTEM_ATTACH | CHAR(1) | Indicates whether the tasks attached with this
transaction are attached as system tasks. Values are:
|
SYSTEM_RUNAWAY | CHAR(8) | Indicates whether the transaction is governed
by the system runaway limit. Values are:
|
TASKDATAKEY | CHAR(8) | The storage key for the task-lifetime storage associated with the transaction. Values are: CICS and USER. |
TASKDATALOC | CHAR(8) | The storage location for the task-lifetime storage
associated with the transaction. Values are:
|
TCLASS | CHAR(1) | Indicates whether the transaction belongs to
a transaction class. Values are:
|
TCLASS_NAME | CHAR(8) | The name of the transaction class that the transaction belongs to. |
TPURGE | CHAR(1) | Indicates whether the transaction is purgeable
in the event of a VTAM® terminal
error. Values are:
|
TRACE | CHAR(8) | The level of tracing defined for the transaction. Values are: SPECIAL, STANDARD, and SUPPRESSED. |
TRAN_ROUTING_PROFILE | CHAR(8) | The name of the profile CICS uses to route the transaction to a remote system. |
PRIMARY_TRANSID | CHAR(4) | The primary transaction identifier for the transaction definition. |
TWASIZE | INTEGER | The size of the transaction work area specified on the transaction definition. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |