The structure of the Command Flow table objects

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

CIU_CMDFLOW_DATA
This table stores information about every unique detail of the commands issued by the transaction.
Table 1. The CIU_CMDFLOW_DATA table
Column Type Description
CMDFLOW_ID CHAR(08) Name of the command flow trace.
Start of changeTRACE_ID End of change Start of changeCHAR(16) End of change Start of changeUnique Command Flow run ID. End of change
APPLID CHAR(8) CICS® region APPLID.
SYSID CHAR(4) SYSID of local region.
TRANSID CHAR(4) CICS transaction ID.
TASKID CHAR(4) The transaction task ID, from which the command is invoked.
DISTRIBUTED_UOW CHAR(27) Distributed (Network) unit of work for task (the value of this field is the distributed UOW value 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 invoking the command.
OFFSET CHAR(8) The offset of the command from the start of the program.
FUNCTION CHAR(24) Command name.
TYPE CHAR(16) Resource type.
FUNCTION_TYPE CHAR(8) The type of command, DB2®, DLI, 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_DESC CHAR(32) The description of the command (if known).
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.
PREV_TCBMODE CHAR(2) The TCB Mode value 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 invoked before a TCB mode switch
N
Not the last command invoked 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 invoked after a TCB mode switch
N
Not the last command invoked after a TCB mode switch
CICS_VERSION CHAR(4) The version of CICS from which the data is recorded.
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.
Start of changeCMD_USER_DAT1 End of change Start of changeCHAR(48)End of change Start of changeUser data 1 provided by the Command Flow User Exit program.End of change
Start of changeCMD_USER_DAT2 End of change Start of changeCHAR(48)End of change Start of changeUser data 2 provided by the Command Flow User Exit program.End of change
Start of changeCMD_USER_DAT3 End of change Start of changeCHAR(48)End of change Start of changeUser data 3 provided by the Command Flow User Exit program.End of change
CIU_CMDFLOW_INDEX
This table contains all instances of the command flows that have been ran.
Start of change
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 run if specified.
CMD_APPLID2 CHAR(08) Applid of the CICS region 2 for this Command Flow run if specified.
CMD_APPLID3 CHAR(08) Applid of the CICS region 3 for this Command Flow run if specified.
CMD_APPLID4 CHAR(08) Applid of the CICS region 4 for this Command Flow run if specified.
CMD_APPLID5 CHAR(08) Applid of the CICS region 5 for this Command Flow run if specified.
CMD_APPLID6 CHAR(08) Applid of the CICS region 6 for this Command Flow run if specified.
CMD_APPLID7 CHAR(08) Applid of the CICS region 7 for this Command Flow run if specified.
CMD_APPLID8 CHAR(08) Applid of the CICS region 8 for this Command Flow run if specified.
CMD_APPLID9 CHAR(08) Applid of the CICS region 9 for this Command Flow run if specified.
CMD_APPLID10 CHAR(08) Applid of the CICS region 10 for this Command Flow run if specified.
CMD_APPLID11 CHAR(08) Applid of the CICS region 11 for this Command Flow run if specified.
CMD_APPLID12 CHAR(08) Applid of the CICS region 12 for this Command Flow run if specified.
CMD_APPLID13 CHAR(08) Applid of the CICS region 13 for this Command Flow run if specified.
CMD_APPLID14 CHAR(08) Applid of the CICS region 14 for this Command Flow run if specified.
CMD_APPLID15 CHAR(08) Applid of the CICS region 15 for this Command Flow run if specified.
CMD_TRANID1 CHAR(04) Transaction captured by the trace.
CMD_TRANID2 CHAR(04) Transaction captured by the trace.
CMD_TRANID3 CHAR(04) Transaction captured by the trace.
CMD_TRANID4 CHAR(04) Transaction captured by the trace.
CMD_TRANID5 CHAR(04) Transaction captured by the trace.
CMD_COUNT INTEGER Number of records captured during trace in this region.
CMD_APPLNAME CHAR(8) Application name.
CMD_USERID CHAR(8) Traced UserID.
CMD_TERMID CHAR(4) Traced TermID.
JOURNAL_NAME CHAR(8) Journal name.
JOURNAL_COPY_HLQ CHAR(35) Reserved.
USER_EXIT_NAME CHAR(8) Start of changeThe name of Command Flow User Exit program.End of change
End of change