DB2 variables
The DB2® variables that are required to define the CICS® IA DB2 databse
- 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.
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 CIU53DB.
- 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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to CIUIA53.
- 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 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.
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 CIU53SPC.
- 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 CIU53NDX.
- 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 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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA53BTCH.
- 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.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to IA53COLL.
- 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.
OPTIONAL. For a Short configuration, this field is not displayed.
- 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.