Start of change

Application dependency views

The application dependency views show gathered data about any CICS®, DB2®, WebSphere® MQ, and IMS™ application dependency.

V_CIU_CICS_INDS2
This view is a simple DB2 equijoin of CIU_CICS_CHAINP and CIU_CICS_DATA, by using the COLLECTION_ID and BACK_PROG fields in the CIU_CICS_CHAINP table and the COLLECTION_ID and PROGRAM fields in CIU_CICS_DATA table.

You can use the V_CIU_CICS_INDS2 view to display both the direct and indirect CICS commands that are used by the initial program. The following table is used to create views to identify "Application" entry points by the CICS IA Explorer plug-in.

Table 1. View V_CIU_CICS_INDS2
Column Type Description
COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded.
FRONT_PROG CHAR(8) Calling program.
BACK_PROG CHAR(8) Called program.
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.
FUNCTION CHAR(24) EXEC CICS command.
TYPE CHAR(16) CICS resource type.
OBJECT CHAR(255) Resource name.
RMTSYSID CHAR(4) Remote SYSID if relevant.
USECOUNT INTEGER Number of occurrences.
FIRST_RUN TIMESTAMP Time of first occurrence.
LAST_RUN TIMESTAMP Time of last occurrence.
V_CIU_DB2_INDS2
This view is a simple DB2 equijoin of CIU_CICS_CHAINP and CIU_DB2_DATA, by using the COLLECTION_ID and BACK_PROG fields in the CIU_CICS_CHAINP table and the COLLECTION_ID and PROGRAM fields in CIU_DB2_DATA table.

You can use the V_CIU_DB2_INDS2 view to display both the direct and indirect DB2 commands that are used by the initial program. The following table is used to create views to identify "Application" entry points by the CICS IA Explorer plug-in.

Table 2. View V_CIU_DB2_INDS2
Column Type Description
COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded.
FRONT_PROG CHAR(8) Calling program.
BACK_PROG CHAR(8) Called program.
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.
FUNCTION CHAR(24) EXEC CICS command.
RESTYPE CHAR(16) DB2 resource type.
RESNAME CHAR(255) Resource name.
USECOUNT INTEGER Number of occurrences.
FIRST_RUN TIMESTAMP Time of first occurrence.
LAST_RUN TIMESTAMP Time of last occurrence.
V_CIU_MQ_INDS2
This view is a simple DB2 equijoin of CIU_CICS_CHAINP and CIU_MQ_DATA, by using the COLLECTION_ID and BACK_PROG fields in the CIU_CICS_CHAINP table and the COLLECTION_ID and PROGRAM fields in CIU_MQ_DATA table.

You can use the V_CIU_MQ_INDS2 view to display both the direct and indirect MQ commands that are used by the initial program. The following table is used to create views to identify "Application" entry points by the CICS IA Explorer plug-in.

Table 3. View V_CIU_MQ_INDS2
Column Type Description
COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded.
FRONT_PROG CHAR(8) Calling program.
BACK_PROG CHAR(8) Called program.
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.
FUNCTION CHAR(24) EXEC MQ command.
TYPE CHAR(16) MQ resource type.
OBJECT CHAR(255) Resource name.
USECOUNT INTEGER Number of occurrences.
FIRST_RUN TIMESTAMP Time of first occurrence.
LAST_RUN TIMESTAMP Time of last occurrence.
V_CIU_IMS_INDS2
This view is a simple DB2 equijoin of CIU_CICS_CHAINP and CIU_IMS_DATA, by using the COLLECTION_ID and BACK_PROG fields in the CIU_CICS_CHAINP table and the COLLECTION_ID and PROGRAM fields in CIU_IMS_DATA table.

You can use the V_CIU_IMS_INDS2 view to display both the direct and indirect IMS commands that are used by the initial program. The following table is used to create views to identify "Application" entry points by the CICS IA Explorer plug-in.

Table 4. View V_CIU_IMS_INDS2
Column Type Description
COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded.
FRONT_PROG CHAR(8) Calling program.
BACK_PROG CHAR(8) Called program.
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.
FUNCTION CHAR(24) EXEC DLI command.
TYPE CHAR(16) IMS resource type.
OBJECT CHAR(255) Resource name.
USECOUNT INTEGER Number of occurrences.
FIRST_RUN TIMESTAMP Time of first occurrence.
LAST_RUN TIMESTAMP Time of last occurrence.
End of change