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.