Previous Topic: IT VariablesNext Topic: COBOL Compiler Variables


DB2 Database Variables

The following table describes the DB2 database variables.

DB2 Database Variables

Description

User Notes

DB2 Subsystem ID
Default: DSN

Identifies the DB2 subsystem.

 

DB2 Collection ID Default: DBCOLLID

Identifies DB2 collection ID used in binding z/OS IT packages.

 

Explicit creator ID No default

If specified, the z/OS IT’s tables and indexes are qualified using this ID. Explicit creator ID and secondary authorization ID are mutually exclusive.

 

Secondary authorization ID No default

If specified, current SQLID is set to this ID before IT tables and indexes are defined. Secondary authorization and explicit creator ID are mutually exclusive.

 

Database name Default: MVSIT

Name of the IT’s database.

 

Dataset storage type Default: S

Space for the IT’s database can be allocated using storage groups or VSAM data sets: S for storage group allocation, V for VSAM.

 

Initial database size Default: S

S-small

M-medium

 

Secondary storage factor Default: 0

Defines secondary space allocation in relation to primary allocation. (0 to 1.0 times primary allocation.)

 

Storage Group Names No default

If you select storage group space allocation, you must know the names of the groups to use.

 

VSAM Volume Names No default

If you select VSAM space allocation, you must specify the volume names for VSAM data sets.

 

Gen Runtime Collection ID Default: RTCOLLID

Identifies DB2 collection ID used in binding runtime packages for TIRPROFD and TIROLBCM.