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.
PLATFORM CHAR(64) Platform name.
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, that is, CICS, CICSPlex® SM, DB2®, DLI, or WebSphere® MQ, or the name of the task related user exit (TRUE) 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.
CMD_TCB_CPUTIME _BEFORE Start of changeCHAR(20)End of change Start of changeThe processor time during which the user task was dispatched by the CICS dispatcher domain, recorded before the current CICS command started. (1)End of change
CMD_TCB_CPUTIME _AFTER Start of changeCHAR(20)End of change Start of changeThe processor time during which the user task was dispatched by the CICS dispatcher domain, recorded after the current CICS command ended. For LINK, the field value is 20C’0'. (1)End of change
CMD_TIME_LOCAL TIMESTAMP The time the command was issued, in the local time format.
Start of changeCMD_RMTSYSIDEnd of change Start of changeCHAR(4) End of change Start of changeStart of changeThe remote SYSID, if relevant. (2)End of changeEnd of change
Start of changeCMD_RMTNAMEEnd of change Start of changeCHAR(8)End of change Start of changeThe name by which the resource is known in the remote region.End of change
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.
CMD_OD_FACILTYPE INTEGER Originating facility type.
CMD_OD_IPFAMILY INTEGER Originating client IP address format.
CMD_OD_CLNTPORT INTEGER Originating TCP/IP stack port number.
CMD_PH_COUNT INTEGER Previous Hop count.
CMD_OD_TASKID CHAR(08) Originating task.
CMD_PH_TASKID CHAR(08) Previous Hop task ID.
CMD_OD_STARTTIM CHAR(21) Originating task start time.
CMD_PH_STARTTIM CHAR(21) Previous Hop task start time.
CMD_STARTTIM CHAR(21) This is the time the task on the previous hop started.
CMD_OD_ADPTRID CHAR(64) Originating adapter ID.
CMD_OD_ADPTRD1 CHAR(64) Originating adapter data.
CMD_OD_ADPTRD2 CHAR(64) Originating adapter data.
CMD_OD_ADPTRD3 CHAR(64) Originating adapter data.
CMD_OD_APPLID CHAR(08) APPLID taken from the origin descriptor associated with this task.
CMD_OD_CLNTIPAD CHAR(39) Originating client IP address.
CMD_OD_FACILNM CHAR(08) Originating facility name.
CMD_OD_LUNAME CHAR(08) Originating VTAM LU name.
CMD_OD_NETID CHAR(08) Originating network ID.
CMD_OD_NETWORKI CHAR(08) Originating network ID.
CMD_OD_TRANSID CHAR(04) Originating transaction ID.
CMD_OD_USERID CHAR(08) Originating user ID.
CMD_PH_APPLID CHAR(08) Previous Hop APPLID.
CMD_PH_NETWORKI CHAR(08) Previous Hop NETWORKID.
CMD_PH_TRANSID CHAR(04) Previous Hop transaction ID.
Note: Start of change1. The field value in the database and in the CSV file is a decimal character value. 1 unit (00000000000000000001) is equal to 1/4096000 of a millisecond. The CICS IA plug-in displays the value in milliseconds. If the value is 0 then the CICS IA plug-in displays a blank value.End of change
Note: Start of change2. If the command is shipped or routed to a remote region, these characters represent the system identifier (SYSID) of the remote region. End of change
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.