The structure of the Command Flow table objects

This section describes the Command Flow base table that contains records for each command that is issued by the transactions. You can write your own SQL applications to query the table; these applications must use native SQL to write the queries.

CIU_CMDFLOW_DATA
This table stores information about every unique detail of the commands that are issued by the transaction.
Table 1. The CIU_CMDFLOW_DATA table
Column Type Description
TRACE_ID CHAR(16) Unique Command Flow run ID.
CMDFLOW_ID CHAR(08) Name of the command flow trace.
APPLID CHAR(8) CICS® region APPLID.
SYSID CHAR(4) SYSID of local region.
APP_NAME CHAR(64) Application name
APP_VER1 INTEGER Major version number
APP_VER2 INTEGER Minor version number
APP_VER3 INTEGER Micro version number
APP_OPER CHAR(64) The operation that is associated with the task
TRANSID CHAR(4) CICS transaction ID.
TASKID CHAR(4) The transaction task ID, from which the command is started.
DISTRIBUTED_UOW CHAR(27) Distributed (Network) unit of work for task (the value of this field is the distributed UOW value that is recorded in the start of task).
CICS_UOW CHAR(8) CICS unit of work for task.
USERID CHAR(8) The CICS user ID of the transaction.
CONCURRENCY CHAR(10) Threadsafe. Quasirent. The value of this field is determined from the first program started for the transaction.
API CHAR(8) CICSAPI; OPENAPI. The value of this field is determined from the first program started for the transaction.
"PROGRAM" CHAR(8) The name of the CICS program that starts the command.
OFFSET CHAR(8) The offset of the command from the start of the program.
FUNCTION_TYPE CHAR(8) The type of command, DB2®, DLI, WebSphere MQ, CICS, or the name of the TRUE exit if the type of command cannot be determined.
FUNCTION_ID CHAR(4) The function ID of the command.
FUNCTION CHAR(24) Command name.
TYPE CHAR(16) Resource type.
RESOURCE_NAME CHAR(32) The name of the resource the command is acting upon (if known).
TCBMODE CHAR(2) The TCB Mode value at the time the command is processed.
FUNCTION_DESC CHAR(32) The description of the command (if known).
PREV_TCBMODE CHAR(2) The TCB Mode value that is recorded for the previous command. The value of this field is determined by the batch DB2 table upload program.
BEFORE_MODESWITCH CHAR(1) This field is determined by comparing the TCB mode of this command to the following command. The value is determined by the batch DB2 upload program.
Y
Last Command that is started before a TCB mode switch
N
Not the last command that is started before a TCB mode switch
AFTER_MODESWITCH CHAR(1) This field is determined by comparing the TCB mode of this command to the previous command. The value is determined by the batch DB2 upload program.
Y
Last Command that is started after a TCB mode switch
N
Not the last command that is started after a TCB mode switch
TCB_SWITCH_BEFORE _COUNT INTEGER Number of TCB mode switches from task start to start of execution of current EXEC CICS command.
TCB_SWITCH_AFTER _COUNT INTEGER Number of TCB mode switches from task start to end of execution of current EXEC CICS command.
CICS_VERSION CHAR(4) The version of CICS from which the data is recorded.
Start of change CMD_TCB_CPUTIME _BEFORE End of change Start of change CHAR(16) End of change Start of change The processor time during which the user task was dispatched by the CICS dispatcher domain, recorded before the current CICS command started. End of change
Start of change CMD_TCB_CPUTIME _AFTER End of change Start of change CHAR(16) End of change Start of change The processor time during which the user task was dispatched by the CICS dispatcher domain, recorded after the current CICS command ended. End of change
CMD_TIME_LOCAL TIMESTAMP Time the command was issued, in the local time format.
CMD_EIBRESP CHAR(08) The response code is EIBRESP.
CMD_EIBRESP2 CHAR(08) The response code is EIBRESP2.
CMD_EIDARG0_DATA CHAR(56) The Argument zero value of EXEC CICS command, in alphanumeric form.
CMD_USER_DAT1 CHAR(48) User data 1 provided by the Command Flow User Exit program.
CMD_USER_DAT2 CHAR(48) User data 2 provided by the Command Flow User Exit program.
CMD_USER_DAT3 CHAR(48) User data 3 provided by the Command Flow User Exit program.
CIU_CMDFLOW_INDEX
This table contains all instances of the command flows that have run.
Table 2. The CIU_CMDFLOW_INDEX table
Column Type Description
OWNER_USERID CHAR(8) Name of USER collecting commands.
TRACE_ID CHAR(16) Unique Command Flow run ID.
CMDFLOW_ID CHAR(08) Name of the command flow trace.
COL_APPLID CHAR(08) APPLID of the CICS region in which it was collected.
CMD_TIME_START TIMESTAMP Date and time of collection start, in the local time format.
CMD_TIME_END TIMESTAMP Date and time of collection end, in the local time format.
CMD_APPLID1 CHAR(08) APPLID of the CICS region 1 for this Command Flow that is run if specified.
CMD_APPLID2 CHAR(08) APPLID of the CICS region 2 for this Command Flow that is run if specified.
CMD_APPLID3 CHAR(08) APPLID of the CICS region 3 for this Command Flow that is run if specified.
CMD_APPLID4 CHAR(08) APPLID of the CICS region 4 for this Command Flow that is run if specified.
CMD_APPLID5 CHAR(08) APPLID of the CICS region 5 for this Command Flow that is run if specified.
CMD_APPLID6 CHAR(08) APPLID of the CICS region 6 for this Command Flow that is run if specified.
CMD_APPLID7 CHAR(08) APPLID of the CICS region 7 for this Command Flow that is run if specified.
CMD_APPLID8 CHAR(08) APPLID of the CICS region 8 for this Command Flow that is run if specified.
CMD_APPLID9 CHAR(08) APPLID of the CICS region 9 for this Command Flow that is run if specified.
CMD_APPLID10 CHAR(08) APPLID of the CICS region 10 for this Command Flow that is run if specified.
CMD_APPLID11 CHAR(08) APPLID of the CICS region 11 for this Command Flow that is run if specified.
CMD_APPLID12 CHAR(08) APPLID of the CICS region 12 for this Command Flow that is run if specified.
CMD_APPLID13 CHAR(08) APPLID of the CICS region 13 for this Command Flow that is run if specified.
CMD_APPLID14 CHAR(08) APPLID of the CICS region 14 for this Command Flow that is run if specified.
CMD_APPLID15 CHAR(08) APPLID of the CICS region 15 for this Command Flow that is run if specified.
CMD_TRANID1 CHAR(04) Transaction that is captured by the trace.
CMD_TRANID2 CHAR(04) Transaction that is captured by the trace.
CMD_TRANID3 CHAR(04) Transaction that is captured by the trace.
CMD_TRANID4 CHAR(04) Transaction that is captured by the trace.
CMD_TRANID5 CHAR(04) Transaction that is captured by the trace.
CMD_COUNT INTEGER Number of records that are captured during trace in this region.
CMD_APPLNAME CHAR(8) Application name.
CMD_USERID CHAR(8) Traced user ID.
CMD_TERMID CHAR(4) Traced term ID.
JOURNAL_NAME CHAR(8) Journal name.
JOURNAL_COPY_HLQ CHAR(35) Reserved.
USER_EXIT_NAME CHAR(8) The name of Command Flow User Exit program.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


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