
Transaction dependency views
The transaction dependency views show data that is gathered about any CICS®, DB2®, WebSphere® MQ, and IMS™ application dependency.
- V_CIU_CICS_TRANSID_DET
- This view is a simple DB2 equijoin of the CIU_TRANSID_DETAIL table and the V_CIU_CICS_INDS2 view, by
using the INITIAL_PROGRAM field in the CIU_TRANSID_DETAIL table and the FRONT_PROG field in the
V_CIU_CICS_INDS2 view.
You can use the V_CIU_CICS_TRANSID_DET view to display both the direct and indirect CICS commands that are used by a transaction and the initial program. The following table is used by the DB2 stored procedures to identify "Application" entry points by the CICS IA Explorer plug-in.
Table 1. View V_CIU_CICS_TRANSID_DET Column Type Description COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded. APPLID CHAR(8) CICS region applid. PLATFORM CHAR(64) Platform name. APPL_NAME CHAR(64) Application name. APPL_VER1 INTEGER Major version number. APPL_VER2 INTEGER Minor version number. APPL_VER3 INTEGER Micro version number. APPL_OPER CHAR(64) The operation that is associated with the task. TRANSID CHAR(4) CICS Transaction ID. INITIAL_PROGRAM CHAR(8) Initial program. BACK_PROG CHAR(8) Called program. FUNCTION CHAR(24) EXEC CICS command. TYPE CHAR(16) CICS resource type. OBJECT CHAR(255) Resource name. - V_CIU_DB2_TRANSID_DET
- This view is a simple DB2 equijoin of the CIU_TRANSID_DETAIL table and the
V_CIU_DB2_INDS2 view, by using the INITIAL_PROGRAM field in the CIU_TRANSID_DETAIL table and the
FRONT_PROG field in V_CIU_DB2_INDS2 view.
You can use the V_CIU_DB2_TRANSID_DET view to display both the direct and indirect DB2 commands that are used by a transaction and the initial program. The following table is used by the DB2 stored procedures to identify "Application" entry points in the CICS IA Explorer plug-in.
Table 2. View V_CIU_DB2_TRANSID_DET Column Type Description COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded. APPLID CHAR(8) CICS region applid. PLATFORM CHAR(64) Platform name. APPL_NAME CHAR(64) Application name. APPL_VER1 INTEGER Major version number. APPL_VER2 INTEGER Minor version number. APPL_VER3 INTEGER Micro version number. APPL_OPER CHAR(64) The operation that is associated with the task. TRANSID CHAR(4) CICS Transaction ID. INITIAL_PROGRAM CHAR(8) Initial program. BACK_PROG CHAR(8) Called program. FUNCTION CHAR(24) SQL DLI command. RESTYPE CHAR(16) DB2 resource type. RESNAME CHAR(255) Resource name. - V_CIU_MQ_TRANSID_DET
- This view is a simple DB2 equijoin of the CIU_TRANSID_DETAIL table and the
V_CIU_MQ_INDS2 field, by using the INITIAL_PROGRAM field in the CIU_TRANSID_DETAIL table and the
FRONT_PROG field in the V_CIU_MQ_INDS2 view.
You can use the V_CIU_MQ_TRANSID_DET view to display both the direct and indirect MQ commands that are used by a transaction and the initial program. The following table is used by the DB2 stored procedures to identify "Application" entry points by the CICS IA Explorer plug-in.
Table 3. View V_CIU_MQ_TRANSID_DET Column Type Description COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded. APPLID CHAR(8) CICS region applid. PLATFORM CHAR(64) Platform name. APPL_NAME CHAR(64) Application name. APPL_VER1 INTEGER Major version number. APPL_VER2 INTEGER Minor version number. APPL_VER3 INTEGER Micro version number. APPL_OPER CHAR(64) The operation that is associated with the task. TRANSID CHAR(4) CICS Transaction ID. INITAL_PROGRAM CHAR(8) Initial program. BACK_PROG CHAR(8) Called program. FUNCTION CHAR(24) EXEC MQ command. TYPE CHAR(16) MQ resource type. OBJECT CHAR(255) Resource name. - V_CIU_IMS_TRANSID_DET
- This view is a simple DB2 equijoin of the CIU_TRANSID_DETAIL table and the
V_CIU_IMS_INDS2 view, by using the INITIAL_PROGRAM field in the CIU_TRANSID_DETAIL table and the
FRONT_PROG field in the V_CIU_IMS_INDS2 view.
You can the V_CIU_IMS_TRANSID_DET view to display both the direct and indirect IMS commands that are used by a transaction and the initial program. The following table is used by the DB2 stored procedures to identify "Application" entry points by the CICS IA Explorer plug-in.
Table 4. View V_CIU_IMS_TRANSID_DET Column Type Description COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded. APPLID CHAR(8) CICS region applid. PLATFORM CHAR(64) Platform name. APPL_NAME CHAR(64) Application name. APPL_VER1 INTEGER Major version number. APPL_VER2 INTEGER Minor version number. APPL_VER3 INTEGER Micro version number. APPL_OPER CHAR(64) The operation that is associated with the task. TRANSID CHAR(4) CICS Transaction ID. INITAL_PROGRAM CHAR(8) Initial program. BACK_PROG CHAR(8) Called program. FUNCTION CHAR(24) EXEC DLI command. TYPE CHAR(16) IMS resource type. OBJECT CHAR(255) Resource name.
