DB2 Catalog and Directory Panel (DSNTIPA2)

This topic shows detailed information about "System Parameters - DB2 Catalog and Directory Panel (DSNTIPA2)".

System Parameters - DB2 Catalog and Directory Panel (DSNTIPA2)

The field labels shown in the following sample layout of "System Parameters - DB2 Catalog and Directory Panel (DSNTIPA2)" are described in the following section.

DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)                      
------------------------------------------                     
SMS DATA CLASS FOR CATALOG DATA (CATDDACL)..................N/P
SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............N/P
SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)............SCPROD
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)............N/P
SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......N/P
SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL)......SCPROD
COMPRESS SPT01 (COMPRESS_SPT01).............................YES
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)................32,138

SMS DATA CLASS FOR CATALOG DATA (CATDDACL)

The SMS data class for DB2 catalog data sets. This field corresponds to column SMS data class in field "Directory and catalog data" on installation panel DSNTIPA3. The ZPARM name is CATDDACL in DSN6SPRM.

Field Name: QWP4CDDC

SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)

The SMS management class for DB2 catalog data sets. This field corresponds to column SMS MGMT class in field "Directory and catalog data" on installation panel DSNTIPA3. The ZPARM name is CATDMGCL in DSN6SPRM.

Field Name: QWP4CDMC

SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)

The SMS storage class for DB2 catalog data sets. This field corresponds to column SMS STOR class in field "Directory and catalog data" on installation panel DSNTIPA3. The ZPARM name is CATDSTCL in DSN6SPRM.

Field Name: QWP4CDSC

SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)

The SMS data class for DB2 catalog index data sets. This field corresponds to column SMS data class in field "Directory and catalog indexes" on installation panel DSNTIPA3. The ZPARM name is CATXDACL in DSN6SPRM.

Field Name: QWP4CXDC

SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)

The SMS management class for DB2 catalog index data sets. this field corresponds to column SMS MGMT class in field "Directory and catalog indexes" on installation panel DSNTIPA3. The ZPARM name is CATXMGCL in DSN6SPRM.

Field Name: QWP4CXMC

SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL)

The SMS storage class for DB2 catalog index data sets. This field corresponds to column SMS STOR class in field "Directory and catalog indexes" on installation panel DSNTIPA3. The ZPARM name is CATXSTCL in DSN6SPRM.

Field Name: QWP4CXSC

COMPRESS SPT01 (COMPRESS_SPT01)

Start of change Enables the compression of SPT01. End of change

Field Name: QWP4CS01

SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)

The maximum length in bytes of LOB columns in the SPT01 directory space that are maintained in the base table. This field corresponds to field SPT01 INLINE LENGTH on installation panel DSNTIPA2. The ZPARM name is SPT01_INLINE_LENGTH in DSN6SPRM.

Field Name: QWP4S1IL

Feedback