Creating the upgraded DB2 environment
This section describes the steps that are required to define your CICS® IA DB2® database and how to review and submit the sample jobs that you configured in the previous section.
- hlq.SCIUSAMP.DB2
- hlq.SCIUSQL.DB2
- hlq.SCIUDAT1.DB2
- hlq.SCIUDAT2.DB2
If you chose to use the first upgrade method Copy the previous CICS IA DB2 tables to a new database, perform the tasks that are described in Step - 1A Creating and updating the IA DB2 database, and then proceed to Step 1C - Updating the stored procedures.
If you chose to use the second upgrade method,Upgrade the previous CICS IA DB2 database to the new structure, perform the tasks that are described in Step 1B - Updating the IA DB2 database and then proceed to Step 1C - Updating the stored procedures.
Step - 1A Creating and updating the IA DB2 database
- Review sample job CIUDBCQ in hlq.SCIUSAMP.DB2.
- Review the associated SQL member, CIUMAIN, in hlq.SCIUSQL.DB2.
- Run sample job CIUDBCQ to create the database objects. This job completes with a return code of 0.
To copy the data from your previous CICS IA database, perform the following steps:
- Review and run sample job CIUMIG32 to copy the data. This job completes with a return code of 0.
- Review and run sample job CIUMIG51 to copy the data. This job completes with a return code of 0.

- Before upgrading the Command Flow data, ensure that APAR PI29675 is installed in your CICS IA V5.2 system. If this APAR is not installed, install APAR PI29675.
- Review and run sample job CIUMIG52 to copy the data. This job completes with a return code of 0.

Step 1B - Updating the IA DB2 database
To update your existing CICS IA database, perform the following steps:
- Review and run sample job CIUNMG32 to update the database structure. This job completes with a return code of 0.
- Review and run sample job CIUNMG51 to update the database structure. This job completes with a return code of 0.

- Before upgrading the Command Flow data, ensure that APAR PI29675 is installed in your CICS IA V5.2 system. If this APAR is not installed, install APAR PI29675.
- Review and run sample job CIUNMG52 to copy the data. This job completes with a return code of 0.

- Review and run sample job CIUNMGQD to update the database structure. This job completes with a return code of 0


Step 1C - Updating the stored procedures
- Review the sample job CIUDBCP1 in hlq.SCIUSAMP.DB2.
- Review the associated SQL member, CIUSPDL1, in hlq.SCIUSQL.DB2 and remove the comments to DROP the Stored Procedures.
- Run sample job CIUDBCP1 to create the database objects. This job completes with return code 0.
- Review the sample job CIUDBCP2 in hlq.SCIUSAMP.DB2.
- Review the associated SQL member, CIUSPDL2, in hlq.SCIUSQL.DB2 and remove the comments to DROP the Stored Procedures.
- Run sample job CIUDBCP2 to create the database objects. This job completes with return code 0.
Step 2 - Rebind the IA DB2 packages
- Review the sample job CIUDBNB in hlq.SCIUSAMP.DB2.
- Review the associated SQL member, CIUGRNTB, in hlq.SCIUSQL.DB2. This sample member includes sample SQL to grant a RACF® group or user ID access to the CICS IA plans. It is used in the STEP 3 of the sample job.
- Run the sample job CIUDBNB to bind the DB2 batch programs that are used by CICS IA sample jobs and to grant access to the bound plan. This job completes with a return code 0.
Step 3 - Loading static DB2 tables
- CIU_VERSION
- The CIU_VERSION table contains the CICS IA
Version and Service information and is used by the CICS IA plug-in for CICS Explorer®.
- To load the version table, review and run job hlq.SCIUSAMP.DB2(CIUVERLD). This job completes with a return code 0.
- CIU_TRANSLATORS
- The CIU_TRANSLATORS table contains a one to one relationship between
the IBM® program component numbers
for compilers, translators, and linkage editors and a description
for each component.
- To load the translator table, review and run job hlq.SCIUSAMP.DB2(CIUTLOAD). This job completes with a return code 0.
- CIU_THREADSAFE_CMD
- The CIU_THREADSAFE_CMD table contains information on whether an
EXEC CICS command is threadsafe
or not for each version of CICS TS.
It is used by the threadsafe report program and the stored procedure
to determine whether a command is threadsafe.
- To load the threadsafe table, review and run job hlq.SCIUSAMP.DB2(CIUTSLOD). This job completes with a return code 0.
- CIU_TRUEEXIT_INFO
- The CIU_TRUEEXIT_INFO table contains a one to one relationship
between the CICS TRUEs that
are used in your environment and a description for each TRUE. This
table is used by the CICS IA
plug-in for CICS Explorer.
- To add your own TRUEs to the table, edit and save hlq.SCIUDAT2.DB2(CIUTRCD).
- To load the TRUE exit table, review and run job hlq.SCIUSAMP.DB2(CIUTRLOD). This job completes with a return code 0.
Step 4 - Loading the CIU_CICS_CHAINP table (for DB2 V9 onwards)
- Review the sample job CIUCHPFL in hlq.SCIUSAMP.DB2.
- Run the sample job CIUCHPFL. This job completes with a return code 0.
Step 5 - DB2 Stored Procedures Setup
CICS IA uses DB2 Stored Procedures to perform complex DB2 tasks.
If you are running DB2 V910 or later, CICS IA uses Native DB2 stored procedures and these stored procedures are defined in STEP 1C.
If you are running DB2 V810 or earlier, CICS IA uses external stored procedures and these stored procedures are defined in STEP 1C.
You can find more information about implementing DB2 Stored Procedures in the DB2 for z/OS® Administration Guide.