Dependency views

The dependency views show gathered data about dependency.

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 1. 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.