Dependency views

The dependency views show gathered data about dependency.

V_CIU_CICS_INDS
This view is a simple DB2® equi-join of CIU_CICS_DATA, using TRANSID in CIU_CICS_DATA. A selection on FRONT_TXN accesses all the resources, direct and indirect, that this transaction can use. A selection on a resource reports all the FRONT-TXNs that might be affected if the resource is unavailable.
Table 1. View V_CIU_CICS_INDS
Column Type Description
FRONT_TXN CHAR(4) Transaction to be analyzed.
BACK_TXN CHAR(4) Dependent transaction for join to TRANSID.
APPLID CHAR(8) CICS® applid.
HOMESYSID CHAR(4) SYSID of local region.
TRANSID CHAR(4) CICS Transaction ID.
PROGRAM CHAR(8) Currently active CICS program.
FUNCTION CHAR(24) Command, such as READ, LOAD.
TYPE CHAR(16) Resource type, such as FILE, TS.
OBJECT CHAR(50) Object of function.¹
RMTSYSID CHAR(4) Remote SYSID, if relevant
USECOUNT INTEGER Number of times this event has been observed.
FIRST_RUN TIMESTAMP Time of first observation of this event, in the local time format.
LAST_RUN TIMESTAMP Time of latest observation of this event, in the local time format.
Note:
  1. The column is 50 bytes to accommodate program and file names, but the data might occupy less space.
  2. If the command is shipped or routed to a remote region, these characters tell you the system identifier (SYSID) of the remote region.
V_CIU_DB2_RES
This view is a simple DB2 equi-join of CIU_DB2_DATA and SYSIBM.SYSPACKSTMT, using the PROGRAM, SECTION, and STATEMENT fields in CIU_DB2_DATA, and the NAME, SECTNO, and STMTNO fields in SYSIBM.SYSPACKSTMT. You can use it to display the DB2 commands, and therefore the DB2 resources, used by a CICS program.
Table 2. View V_CIU_DB2_RES
Column Type Description
APPLID CHAR(8) CICS applid.
HOMESYSID CHAR(4) SYSID of local region.
DB2ID CHAR(4) DB2 subsystem ID.
TRANSID CHAR(4) CICS Transaction ID.
PROGRAM CHAR(8) CICS program name.
PLAN CHAR(8) DB2 plan ID.
SECTNO SMALLINT The section number, in the source code of the CICS program, at which the DB2 command is issued .
STMTNO SMALLINT The precompiler statement number, in the source code of the CICS program, at which the DB2 command is issued.
STMT CHAR(*) The DB2 command (statement) in SYSIBM.SYSPACKSTMT.
V_CIU_DB2_RES2
This view is the same as V_CIU_DB2_RES, except that it joins CIU_DB2_DATA with SYSIBM.SYSSTMT, rather than SYSIBM.SYSPACKSTMT.