Db2® variables

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

It is recommended that you consult with your IBM® 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, IBM® Db2® 10 on z/OS® in CM is designed so that IBM® Db2® 10 can be used as a drop in replacement for Db2® 9. 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® SDSNEXIT DATA SET NAME: The data set name for the Db2® SDSNEXIT library. If you don't use a Db2® SDSNEXIT library, then use the name of your Db2® SDSNLOAD library instead.
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 IBM® Db2® copy data sets when you use the IBM® Db2® LOAD utility. The qualifier is concatenated with the date and time stamp to create a unique data set name.
REQUIRED 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 .

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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU61DB.

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 IBM® 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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIUIA61.

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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to &SYSUID.

Db2® BUFFERPOOL FOR TBSPC: The Db2® BUFFERPOOL value that is used in the CREATE TABLESPACE DDL statements.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.

Db2® BUFFERPOOL FOR INDEX: The Db2® BUFFERPOOL value that is used in the CREATE INDEX DDL statements.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.

USE EXISTING STORAGE GROUP: If you want to use existing storage groups for your IBM® 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 IBM® Db2® DASD VOLUME and IBM® Db2® VCAT QUALIFIER to create the storage groups. This field defaults to NO.
REQUIRED a for Full configuration. For a Short configuration, this field is not displayed.

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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU61SPC.

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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIU61NDX.

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.
REQUIRED for a Full configuration, if new storage groups are required. For a Short configuration, this field is not displayed and defaults to SYSDA.

Db2® PLAN NAME FOR DSNTEP2: The Db2® plan name for the IBM® Db2® utility DSNTEP2.
REQUIRED.

Db2® PLAN NAME FOR DSNTIAUL: The Db2® plan name for the IBM® 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 IBM® Db2® plan. Access to this plan can then be granted to the required RACF® group or user ID.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA61BTCH.

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 IBM® Db2® batch plan that CICS® IA uses. It is also used when you define the WLM Stored procedures.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA61COLL.

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 an IBM® Db2® plan. Access to this plan is then granted to the authorization ID.
OPTIONAL. For a Short configuration, this field is not displayed.

Db2® WLM PROCEDURE NAME

CICS® IA uses a number of IBM® Db2® stored procedures to process data. The CICS® IA stored procedures are supplied in two formats.

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

For IBM® Db2® 910 and later, Native Db2® stored procedures are supplied. Native stored procedures do not require a WLM address space. For IBM® Db2® 910 and later, leave the field empty.

OPTIONAL.

Db2® CCSID (code page): CICS® IA uses the IBM® 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.