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.

When the configuration utility runs to update your DB2 environment variables, you should have the following output data sets.
  • hlq.SCIUSAMP.DB2
  • hlq.SCIUSQL.DB2
  • hlq.SCIUDAT1.DB2
  • hlq.SCIUDAT2.DB2
The data set hlq.SCIUSAMP.DB2 contains the sample jobs that are required to define, upgrade, and maintain your CICS IA DB2 environment.

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

To create the CICS IA database, perform the following steps:
  • 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:

If you are upgrading from CICS IA V3.2:
  • Review and run sample job CIUMIG32 to copy the data. This job completes with a return code of 0.
If you are upgrading from CICS IA V5.1:
  • Review and run sample job CIUMIG51 to copy the data. This job completes with a return code of 0.
Start of changeIf you are upgrading from CICS IA V5.2:
  • 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.
End of change

Step 1B - Updating the IA DB2 database

To update your existing CICS IA database, perform the following steps:

If you are upgrading from CICS IA V3.2:
  • Review and run sample job CIUNMG32 to update the database structure. This job completes with a return code of 0.
If you are upgrading from CICS IA V5.1
  • Review and run sample job CIUNMG51 to update the database structure. This job completes with a return code of 0.
Start of changeIf you are upgrading from CICS IA V5.2
  • 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.
End of change
If the upgrade is successful, you can delete the temporary files:
  • Review and run sample job CIUNMGQD to update the database structure. This job completes with a return code of 0
Note: Start of changeThe default table space size for tables that are created in the DSN1TIAD step of the CIUNMG32, CIUNMG51, or CIUNMG52 jobs might not suit your system requirements. If they do not, change the size in the corresponding SQL files that are contained in the hlq.SCIUSQL library.End of change

Step 1C - Updating the stored procedures

If you are updating the database on DB2 V9 or later, follow these steps:
  • 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.
If you are updating the database on DB2 V8 or earlier, follow these steps:
  • 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

To bind the DB2 batch packages that are required by the CICS IA database, follow these steps:
  • 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

CICS IA uses the following static 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)

To load the CIU_CICS_CHAINP table, compete the following steps:
  • 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.

External DB2 stored procedures run in a started task that is called WLM (Workload Manager) associated with each DB2 subsystem. Sample JCL for a WLM started task is in hlq.SCIUSAMP.DB2(CIUSPTSK). If you already have a DB2 WLM task, you need to update to change the CICS IA load library hlq.SCIULOAD in the STEPLIB concatenation in this JCL to the latest release.
Note: The name of the started task must match the one that is supplied in the CICS IA configuration variable DB2 WLM PROCEDURE NAME.

You can find more information about implementing DB2 Stored Procedures in the DB2 for z/OS® Administration Guide.