DB2 configuration

After running the configuration utility to define your DB2® database 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 required to define and maintain your CICS® IA DB2 environment. These jobs are listed in the following table.

Table 1. Jobs and files supplied in hlq.SCIUSAMP.DB2
Member Description
CIUALOAD Job to load the CIU_APPLS_DESC and CIU_APPLS_RESOURCES tables.
CIUAPMIG Job to migrate applications from CICS IA V3.1 to CICS IA V3.2.
CIUCLR Job to clear the CIU_CICS_DATA, CIU_DB2_DATA, CIU_MQ_DATA, CIU_NATURAL_DATA, and CIU_IMS_DATA tables.
CIUDBCQ Job to create DB2 tables.
CIUDBCT Job to create indexes for SYSIBM.
CIUDBLOD Sample job to run the DB2 utility LOAD against CICS IA data.
CIUDBNB Job to bind CIUCINB2.
CIUDBNT Job to bind programs that update DB2 tables.
CIUDBN2 Job to bind program CIUAPEXT to CICS IA V2 tables.
CIUDBORG Sample job to run the DB2 utility REORG against CICS IA data.
CIUDBSTA Sample job to run the DB2 utility RUNSTATS against CICS IA data.
CIUDBUNL Sample job to run the DB2 utility UNLOAD against CICS IA data.
CIUIVPLD Job to load the Dependency database objects with IVP-supplied data.
Start of change CIUMIG31 End of change Start of change Sample JCL to migrate DB2 tables from CICS IA V3.1 to CICS IA V5.1. End of change
Start of change CIUMIG32 End of change Start of change Sample JCL to migrate DB2 tables from CICS IA V3.2 to CICS IA V5.1. End of change
Start of change CIUSPTSK End of change Start of change Sample JCL for a DB2 WLM started task. End of change
CIUTLOAD Job to load the CIU_TRANSLATORS table.
CIUTRLOD Job to load a TRUE list into the CIU_TRUEEXIT_INFO table
CIUTSLOD Job to load data into the CIU_THREADSAFE_CMD table.
CIUVERLD Job to update the CIU_VERSION table.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///sample_jobs_db2.html