Environment Profiles › IBM Subsystems › DB2 Profile

DB2 Profile

This is the DB2 environment profile.

This profile has the following environment variables:

DESCRIPTION - DB2 subsystem description

Specifies the description of the DB2 subsystem. Enter a 1 to 512 character mixed case text string.

SUBSYSNAME - DB2 subsystem name

Specifies the DB2 subsystem name. Enter a 1 to 4 character uppercase alphanumeric or national (#,@,$) text string that must begin with an alphabetic or national character.

SSIDDESC - DB2 subsystem description

Specifies the description of the DB2 subsystem. Enter a 1 to 40 character mixed case text string.

VERSION - DB2 version identifier

Specifies the DB2 product version identifier. Enter a 6 digit numeric value in the form vvrrmm. The vv is version, rr is release, and mm is the maintenance level. For example, 100100 for DB2 10.1.00.

SSIDVER - DB2 version identifier

Specifies the DB2 product version identifier. Enter a 3 character value in the form Vnn. The nn is version. For example, V10.

SSIDMODE - DB2 subsystem operational mode

Specifies the DB2 subsystem operational mode. Allowed values are CM, CM8, CM9, ENMF, ENMF8, ENMF9, NFM.

SSBP4KIX - DB2 4K bufferpool index

Specifies the DB2 4K bufferpool index. Allowed values are BP16K0-BP16K9.

SSBP4KTS - DB2 4K bufferpool tablespace

Specifies the DB2 4K bufferpool tablespace. Allowed values are BP0-BP49.

SSBP8K - DB2 8K bufferpool

Specifies the DB2 8K bufferpool. Allowed values are BP8K0-BP8K9.

SSBP16K - DB2 16K bufferpool

Specifies the DB2 16K bufferpool. Allowed values are BP16K0-BP16K9.

SSBP32K - DB2 32K bufferpool

Specifies the DB2 32K bufferpool. Allowed values are BP32K, BP32K1-BP32K9.

SSIDXTYP - DB2 index type

Specifies the DB2 index type. Allowed values are 2, D, P, and blank.

SSPROTCL - DB2 index type

Specifies the DB2 protocol to be used for remote data access. Specify PRIVATE for DB2 V8 and earlier releases, DRDA for DB2 V9 and greater.

SSREMOTE - DB2 index type

Specifies the DB2 DRDA remote bind option. Specify YES or NO to indicate whether the Bind Packages and Plans task should include package binds on remote DB2 subsystems.

LOCATION - DB2 location

Specifies the DB2 location.

LOCSSIC - DB2 location subsystem ID

Specifies the DB2 location subsystem ID.

SDSNLOAD - DB2 load module library data set name

Specifies a DB2 load module library. Enter a 1 to 44 character MVS data set name.

SDSNEXIT - DB2 load modules data set name

Specifies the DB2 load module library containing the subsystem parameter module (DSNHDECP) and user-written exit routines. Enter a 1 to 44 character MVS data set name.

LOADLIB3 - Load module library data set name

Specifies an additional load module library. Enter a blank space, or a 1 to 44 character MVS data set name.

LOADLIB4 - Load module library data set name

Specifies an additional load module library. Enter a blank space, or a 1 to 44 character MVS data set name.

RUNLIB - DB2 RUNLIB load module library data set name

Specifies the DB2 RUNLIB load module library. Enter a blank space, or a 1 to 44 character MVS data set name.

ZPARMLIB - DB2 ZPARMLIB data set name

Specifies the DB2 ZPARMLIB library name. Enter a 1 to 44 character MVS data set name.

ZPARMMEM - DB2 ZPARMLIB member name

Specifies the DB2 ZPARMLIB member name. Enter a 1 to 8 character member name.

BSDS01 - DB2 Recovery Analyzer and Log Analyzer first boot strap data set name

Specifies the first DB2 Recovery Analyzer and Log Analyzer boot strap data set name. Enter a 1 to 44 character MVS data set name.

BSDS02 - DB2 Recovery Analyzer and Log Analyzer second boot strap data set name

Specifies the second DB2 Recovery Analyzer and Log Analyzer boot strap data set name. Enter a 1 to 44 character MVS data set name.

SYSADM - DB2 system administrator user name

Specifies the DB2 install system administrator user ID. Enter a 1 to 8 character user name.

SYSADM2 - DB2 alternate system administrator user name

Specifies the alternate DB2 install system administrator user ID. Enter a 1 to 8 character user name.

CATALIAS - DB2 VCAT high level ID

Specifies the VCAT high level ID for the DB2 system. Enter a 1 to 8 character name.

DSNHDECP - DB2 DECP Module Name

Enter a 1 to 8 character DECP Module name. Enter a single blank space if the subsystem version is not DB2 10 NFM or later. Specify the same value as the DECP() option of the DB2 command STARTR DB2.

XMLDEFVL - DB2 XML Column Default Value

Enter a 1 to 40 character default value for new XML columns. For example: DOCUMENTED 1.0. Enter a single blank space to specify no default value.

DDF - DB2 Distributed Data Facility (DDF) Option

Specifies the DB2 Distributed Data Facility (DDF) option. Select YES if DDF is enabled for this DB2 and NO if it is not.

DSGROUP - DB2 data sharing group name

Specifies the DB2 data sharing group name. Enter a 1 to 8 character data sharing group name.