Dependency facilitating tables

Dependency facilitating tables are used by CICS® IA to gather information that is required for CICS IA processes.

CIU_APPLS_DESC
The CIU_APPLS_DESC table holds the list of applications and a textual description.
Table 1. The CIU_APPLS_DESC table
Column Type Description
APPLIC_CODE CHAR(8) Application code.
APPLIC_NAME CHAR(50) Application Description.
CIU_APPLS_RESOURCES
The CIU_APPLS_RESOURCES table contains all the transactions and programs that make up an application.
Table 2. The CIU_APPLS_RESOURCES table
Column Type Description
APPLIC_CODE CHAR(8) Application code.
APPLIC_TYPE CHAR(8) Resource type (program or transid).
APPLIC_RESNAME CHAR(32) Resource name.
Start of changeCIU_CICS_CHAINPEnd of change
Start of changeThe CIU_CICS_CHAINP table allows a join with the following tables:
  • CIU_CICS_DATA
  • CIU_DB2_DATA
  • CIU_MQ_DATA
  • CIU_IMS_DATA
The CIU_CICS_CHAINP table shows relationships between programs, so that a query on an initial program can show the resources that it uses, and also any resources that are used by other programs that it calls. The call can be made by using an EXEC CICS LINK, an EXEC CICS XCTL, or a dynamic CALL.
Table 3. The CIU_CICS_CHAINP table
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.
For example, if PROGA links to PROGB, and PROGB calls PROG3, then this information is added to the table in three records:
PROGA : PROGB
PROGA : PROGC
PROGB : PROGC
To complete the information that is gathered, further records are added to include immediate dependencies as well as the indirect ones:
PROGA : PROGA
PROGB : PROGB
PROGC : PROGC
End of change
Start of changeCIU_CICS_CONNPEnd of change
Start of changeThe CIU_CICS_CONNP table is a temporary table to speed up the building of the CIU_CICS_CHAINP table. It consists of all of the rows from the CIU_CICS_DATA table that record the CALL, LINK, and XCTL commands. It holds the data from columns TRANSID and OBJECT in the CIU_CICS_DATA table. The OBJECT is reduced to an 8 character field to enable indexes to be used efficiently in joins between it and the CIU_CICS_CHAIN table. The table is re-created at each refresh of the CICS IA tables.
Table 4. The CIU_CICS_CONNP table
Column Type Description
COLLECTION_ID CHAR(16) The collection ID that is assigned when the table is loaded.
PROGRAM CHAR(8) Calling program.
CALLEDPROG CHAR(8) Called program.
End of change
Start of changeCIU_CICS_CHAINP_TEnd of change
Start of changeThe CIU_CICS_CHAINP_T table is a temporary table that is used to build up the entries for the CIU_CICS_CHAINP table, which requires a two stage process. The CIU_CICS_CHAINP_T table has the same layout as the CIU_CICS_CHAINP table.End of change