Transaction resource table

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.

CIU_TRANSID_DETAIL
This table stores detailed information about every CICS® transaction recorded by the Collector. Transaction information is stored in this table only if the Transactions field on the CICS Resources Options panel, CIU240, is set to D.
Table 1. The CIU_TRANSID_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
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:
Y
Yes
N
No
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:
Y
Yes
N
No
DYNAMIC CHAR(1) Indicates whether the transaction is defined for dynamic transaction routing. Values are:
Y
Yes
N
No
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:
Y
The UOW is to wait, pending recovery from a failure, to determine whether recoverable resources are to be backed out or committed.
N
The UOW is not to wait. CICS immediately takes the action specified on the ACTION attribute of the TRANSACTION definition.
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:
Y
Transaction isolation is required.
N
Transaction isolation is not required.
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:
Y
The request can be queued locally.
N
The request is not queued locally.
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:
Y
Yes
N
No
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:
Y
Yes
N
No
RESTART CHAR(1) Indicates whether the transaction is considered for transaction restart. Values are:
Y
The transaction can be restarted.
N
The transaction can not be restarted.
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:
Y
Yes
N
No
STORAGE_CLEAR CHAR(1) Indicates whether task-lifetime storage is cleared before it is freed by a FREEMAIN command. Values are:
Y
Yes
N
No
STORAGE_FREEZE CHAR(1) Indicates whether the storage freeze option is defined for the transaction. Values are:
Y
Yes
N
No
SYSTEM_ATTACH CHAR(1) Indicates whether the tasks attached with this transaction are attached as system tasks. Values are:
Y
Yes
N
No
SYSTEM_RUNAWAY CHAR(8) Indicates whether the transaction is governed by the system runaway limit. Values are:
Y
Yes
N
No
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:
Any
The storage can be located above 16 MB in virtual storage.
Below
The storage must be located below 16 MB in virtual storage.
TCLASS CHAR(1) Indicates whether the transaction belongs to a transaction class. Values are:
Y
Yes
N
No
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:
Y
Yes
N
No
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.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


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