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. CIU_CICS_CHAINP
The CIU_CICS_CHAINP table allows a join with the following tables:
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.- CIU_CICS_DATA
- CIU_DB2_DATA
- CIU_MQ_DATA
- CIU_IMS_DATA
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
CIU_CICS_CONNP
The 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. CIU_CICS_CHAINP_T
The 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.