Previous Topic: Encyclopedia 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.

 

Secondary authorization ID
No default

The DB2 DDL uses secondary authorization ID as:

SET CURRENT SQLID='XXX'

Secondary authorization ID is passed to the DB2 bind process in the OWNER parameter.

 

Bind Qualifier and DB2 Table-Index-View Owner
No default

Optional. Bind qualifier and DB2 Table-Index-View-Owner are passed to the DB2 bind process in the QUALIFER parameter. This value is also used to prefix table, index, and view names, during their creation.

 

DB2 Collection ID
Default: DBCOLLID

Identifies DB2 collection ID used in binding Host Encyclopedia packages.

 

Schema DB name
Default: HOSTS

Name of the schema database.

 

Data DB name
Default: HOSTD

Name of the encyclopedia database.

 

Public Interface DB name
Default: HOSTP

Name of the public interface database.

 

Dataset storage type
Default: S

Space for CA Gen database can be allocated using storage groups or VSAM data sets:
S-storage group allocation
V-VSAM allocation

 

Encyclopedia Initial 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.