Start of change

Customizing DB2 Environment

Besides configuring the CICS® Interdependency Analyzer Collector environment itself, you also need to adjust its working DB2® environment.

You can do it in four steps:

Creating the CICS IA database

CICS IA provides sample job hlq.SCIUSMP2.OUT(CIUDBNT) that binds all DB2 load programs into a DB2 plan. The final step in the sample job runs the DB2 GRANT command that gives access to users who require to run the DB2 load jobs. The GRANT command can be found in member hlq.SCIUSQL.OUT(CIUGRNTB).

To create a CICS IA database, do the following:
  1. Edit and review the sample job CIUDBNT.
  2. Edit and review the GRANT command in CIUGRNTB.
  3. Submit the sample job CIUDBNT.

Binding the programs that update the DB2 tables

CICS IA provides sample job hlq.SCIUSMP2.OUT(CIUDBCQ) that defines all the CICS IA database objects required to store collected data. These objects include TABLES, INDEXES, VIEWS, and Stored Procedures. The sample job runs the Data Definition Language (DDL) commands required to create these objects. The DDL is stored in several members of hlq.SCIUSQL.OUT.

To perform this task, do the following:
  1. Edit and review the sample job CIUDBCQ.
  2. Edit and review the sample DDL in hlq.SCIUSQL.OUT(CIUMAIN).
  3. Submit the sample job CIUDBCQ.

Running the CIUIVPLD job

CICS IA provides sample CICS data that can be loaded into the CIU_CICS_DATA table. This enables you to use the CICS IA Explorer plug-in to view sample data and verify that CICS IA database is created and the connection to the Explorer is working. CICS IA provides sample job hlq.SCIUSMP2(CIUIVPLD) to load this data into the CIU_CICS_DATA table. The data itself is contained in hlq.SCIUDAT(CIUIVPC).

To load sample data to the CIU_CICS_DATA table, edit and run the CIUIVPLD job.

Loading the CIU_VERSION table

CICS IA uses a DB2 table called CIU_VERSION to control which version of the DB2 tables the CICS IA Explorer plug-in is connected to. CICS IA supplies sample job hlq.SCIUSMP2(CIUVERLD) to populate this table.

To load the CIU_VERSION table, edit and run the CIUVERLD job.

End of change