DB2 variables

The DB2® variables that are required to define the CICS® IA DB2 databse

It is recommended that you consult with your DB2 systems programmer before you set these values.
DB2 VERSION
The DB2 version number. This variable is used with DB2 compatibility mode to decide on what is configured in the CICS IA database. This field defaults to V910.

REQUIRED.

DB2 COMPATABILITY MODE
DB2 sub systems can run in compatibility mode (CM) and in new function mode (NF). For example, DB2 V10 on z/OS® in CM is designed so that DB2 V10 can be used as a drop in replacement for DB2 V9. If you are in compatibility mode, set this field to YES. This field is used with the DB2 version number to decide on what is configured in the CICS IA database.

REQUIRED.

DB2 LOAD DATA SET NAME
The data set name for the DB2 SDSNLOAD library.

REQUIRED.

DB2 RUNLIB DATA SET NAME
The data set name for the DB2 RUNLIB.LOAD library.

REQUIRED.

DB2 PROCLIB DATA SET NAME
The data set name for the DB2 PROCLIB library that contains the DSNUPROC.

REQUIRED.

DB2 LOAD TEMPLATE QUALIFIER
The data set qualifier that is used for allocating DB2 copy data sets when you use the DB2 LOAD utility. The qualifier is concatenated with the date and time stamp to create a unique data set name.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and is set to the value that is specified for "HLQ for IA output data sets" .End of change

DB2 SUB SYSTEM
The DB2 sub system identifier in which the CICS IA DB2 data sets are created.

REQUIRED.

DB2 DATABASE FOR TBLSPCS
The IA DB2 database name.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU53DB.End of change

DB2 TABLE QUALIFIER
The DB2 qualifier, which is sometimes referred to as schema for the database objects. This value is used to set the SCHEMA during the creation of the DB2 objects and as the QUALIFIER when the CICS IA DB2 batch programs bind. This value is also required when you connect through the CICS IA plug-in.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIUIA53.End of change

DB2 TABLE OWNER
The TSO user ID that owns the DB2 resources. This value is used to set the CURRENT SQLID during the creation of the DB2 objects and as the OWNER when the CICS IA DB2 batch programs bind.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to &SYSUID.End of change

DB2 BUFFERPOOL FOR TBSPC
The DB2 BUFFERPOOL value that is used in the CREATE TABLESPACE DDL statements.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.End of change

DB2 BUFFERPOOL FOR INDEX
The DB2 BUFFERPOOL value that is used in the CREATE INDEX DDL statements.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.End of change

USE EXISTING STORAGE GROUP
If you want to use existing storage groups for your DB2 STOGROUP values, set this value to YES. If you want CICS IA to create new DB2 storage groups, set this value to NO. CICS IA uses the values that are provided for DB2 DASD VOLUME and DB2 VCAT QUALIFIER to create the storage groups. This field defaults to NO.

Start of changeREQUIRED a for Full configuration. For a Short configuration, this field is not displayed.End of change

DB2 STOGROUP FOR TBLSPCS
The DB2 Storage group value that is used in the CREATE TABLESPACE DDL statements. You can use existing storage groups or request CICS IA to create new storage groups.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU53SPC.End of change

DB2 STOGROUP FOR INDEXES
The DB2 Storage group value that is used in the CREATE INDEX DDL statements. You can use existing storage groups or request CICS IA to create new storage groups.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU53NDX.End of change

DB2 VCAT QUALIFIER
The DB2 data set qualifier under which the CICS IA DB2 data sets are cataloged. This value is used when you create a new CICS IA DB2 storage groups.

REQUIRED if you want new storage groups to be created.

DB2 DASD VOLUME
The DASD volume on which DB2 resources are cataloged. This value is used when you create new CISC IA DB2 storage groups.

Start of changeREQUIRED for a Full configuration, if new storage groups are required. For a Short configuration, this field is not displayed and defaults to SYSDA.End of change

DB2 PLAN NAME FOR DSNTEP2
The DB2 plan name for the DB2 utility DSNTEP2.

REQUIRED.

DB2 PLAN NAME FOR DSNTIAUL
The DB2 plan name for the DB2 utility DSNTIAUL.

REQUIRED.

DB2 PLAN NAME FOR BATCH
CICS IA uses a number of COBOL DB2 programs in batch to load data into the CICS IA database. These programs are bound and packaged into this DB2 plan. Access to this plan can then be granted to the required RACF® group or user ID.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA53BTCH.End of change

DB2 COLLECTION ID
The DB2 collection identifier for the CICS IA DB2 packages. This value is used during the bind of the DB2 packages and the DB2 batch plan that CICS IA uses. It is also used when you define the WLM Stored procedures.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA53COLL.End of change

DB2 AUTHORIZATION ID
The DB2 authorization ID that is used to grant access to the CICS IA DB2 plans. The authorization ID can be set to a RACF user ID, a RACF group or PUBLIC. CICS IA uses a number of COBOL DB2 programs to load data into the database. These programs are bound and packaged into a DB2 plan. Access to this plan is then granted to the authorization ID.

Start of changeOPTIONAL. For a Short configuration, this field is not displayed.End of change

DB2 WLM PROCEDURE NAME
CICS IA uses a number of DB2 stored procedures to process data. The CICS IA stored procedures are supplied in two formats.

If you are on DB2 V810 or earlier, CICS IA uses linked stored procedures. These types of stored procedures need to be added to a DB2 WLM address space. This field is used to specify the WLM address space that is used when you define the stored procedures to DB2.

For DB2 V910 and later, Native DB2 stored procedures are supplied. Native stored procedures do not require a WLM address space. For DB2 V910 and later, leave the field empty.

OPTIONAL.

DB2 CCSID (code page)
CICS IA uses the DB2 LOAD utility to load the collected data into the CICS IA DB2 database. Use the CCSID option of the LOAD utility statement to specify the CCSIDs of the data in the input file.

REQUIRED.