Defining the database

This section describes defining and binding the DB2® objects that make up the CICS® IA database.

About this task

Before you run the installation customization program, read DB2 considerations.

For DB2 tablespace and index allocations, refer to DB2 space allocation.

To define the CICS IA database perform the following steps:
  1. Review sample job CIUDBCQ in hlq.SCIUSAMP.DB2.
  2. Review the associated SQL member, CIUMAIN, in hlq.SCIUSQL.DB2.
  3. Run sample job CIUDBCQ to create the database objects.
To bind the DB2 batch packages required by the CICS IA database perform the following steps:
  1. Review sample job CIUDBNB in hlq.SCIUSAMP.DB2.
  2. Review the associated SQL member, CIUGRNTB, in hlq.SCIUSQL.DB2. This sample member includes sample SQL to grant a RACF® group or userid to the CICS IA plans. It is used in the STEP 3 of the sample job.
  3. Run sample job CIUDBNB to bind the DB2 batch programs used by CICS IA sample jobs and to grant access to the bound plan.
Note: Start of change If you use method 2 in Migrating the DB2 tables you must perform the migration first. After the migration, only run the DB2 bind jobs, do not run the definition job CIUDBCQ. End of change

Task Task

Feedback


Timestamp icon Last updated: Friday, 22 November 2013


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