Start of change

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.
End of change