DSNZPARM Data Parameters
This panel shows information about the parameters that affect the default settings of the DB2 application.It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.
If a field is not available for the current Db2 release, the string N/A is displayed. For other conditions, for example,
if specific Db2 traces are not started or control block data
is not available, the string N/P is displayed.
________________ ZPDAT VTM O2 V550./I SE11 G 06/27/13 21:58:37 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.N
> DSNZPARM INFORMATION: Enter a selection letter on the top line.
> A-THREAD B-TRACE C-LOGGING D-ARCHIVING E-AUTH/RLF/DDF F-IRLM
> G-STORAGE H-DATASET I-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> M-APPL *-DATA O-PERF P-BUFFERPOOL Q-OTHERS
===============================================================================
> DSNZPARM DATA PARAMETERS
ZDAT
+ Collection Interval: REALTIME SNAPTIME: 06/27/13 19:58:37.98
+
+ Member Name SE11 SE12
+ DSNZPARM Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+ Initial Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+ Previous Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+
+ DSNTIPA2-Data
+------------------------------------
+ Catalog Alias (CATALOG) DBE1 DBE1
+ SMS DAT Data Class (CATDDACL) XVSAM XVSAM
+ SMS DAT Mgmt Class (CATDMGCL) DB2 DB2
+ SMS DAT Storage Class (CATDSTCL) DB2 DB2
+ SMS IX Data Class (CATXDACL) XVSAM XVSAM
+ SMS IX Management Class (CATXMGCL) DB2 DB2
+ SMS IX STO Class (CATXSTCL) DB2 DB2
+ Compress SPT01 (COMPRESS_SPT01) NO NO
+ (COMPRESS_DIRLOB) NO NO
+ (SPT01_INLINE_LENGTH) 32138 32138
+
+ DSNTIPO3-Default Startup
+------------------------------------
+ Parameter Module DSNZPARM DSNZPARM
+ Access Control (ACCESS_CNTL_MODULE) DSNX@XAC DSNX@XAC
+ Identify Auth (IDAUTH_MODULE) DSN3@ATH DSN3@ATH
+ Signon (IGNON_MODULE) DSN3@SGN DSN3@SGN
+
+ DSNTIPM-MVS Parameters
+------------------------------------
+ Subsystem Name (SSID) SE11 SE12
+ Supress Soft Errors (SUPERRS) YES YES
=============================================================================== Navigation
For additional information about
- related topics, select one of the options on the top of the panel.
- other topics, use the PF keys.
Fields
The DSNZ command displays the following lines to reflect the usage of the Db2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.
- DSNZPARM Module
- The name of the DSNZPARM module that is specified for Db2 startup.
- Initial Module
- The name of the initial DSNZPARM load module.
- Previous Module
- The name of the previous DSNZPARM load module.
- Assembly Date
- The date on which this module was assembled.
DSNTIPA2-Data
- Catalog Alias (QWP6CATN)
- The value of the CATALOG ALIAS field determines the high-level qualifier for VSAM data sets that are used by the DB2 catalog and directory.
- SMS DAT Data Class (QWP4CDDC), SMS DAT Mgmt Class (QWP4CDMC), SMS DAT Storage Class (QWP4CDSC)
- The DIRECTORY AND CATALOG DATA field determines the explicit Storage Management Subsystem (SMS) classes that are used to define VSAM data sets for the Db2 catalog and directory. Your SMS storage administrator defines these SMS classes.
- SMS IX Data Class (QWP4CXDC), SMS IX Management Class (QWP4CXMC), SMS IX STO Class (QWP4CXSC)
- The DIRECTORY AND CATALOG INDEXES field determines the explicit Storage Management Subsystem (SMS) classes that are used to define VSAM data sets for Db2 catalog and directory indexes. Your SMS storage administrator defines these SMS classes.
- Compress SPT01 (COMPRESS_SPT01) (QWP4CS01)
- The COMPRESS_SPT01 subsystem parameter determines whether the SPT01 directory table space is compressed.
- (COMPRESS_DIRLOB) (QWP4CDRL)
- Specifies whether DB2 compresses LOB table spaces in the DB2 directory the next time that the
table spaces are reorganized. Valid values:
- NO
- LOB table spaces in the DB2 directory are not compressed
- YES
- LOB table spaces in the DB2 directory are compressed the next time they are reorganized.
- (SPT01_INLINE_LENGTH) (QWP4S1IL)
- The SPT01_INLINE_LENGTH subsystem parameter defines the maximum length of LOB column data in the SPT01 directory table space that is maintained in the base table. The length is specified in single-byte characters.
DSNTIP03-Default Startup
- Parameter Module (QWP1ZPNM)
- The PARAMETER MODULE parameter defines the member name of the load module that is used for Db2 subsystem parameters.
- Access Control (ACCESS_CNTL_MODULE) (QWP1DXAC)
- This parameter defines the member name of the load module that is used for the Db2 access control exit routine.
- Identify Auth (IDAUTH_MODULE) (QWP1DATH)
- This parameter determines the member name of the load module that is used for the Db2 connection authorization exit routine.
- Signon (SIGNON_MODULE) (QWP1DSGN)
- This parameter determines the member name of the load module that is used for the Db2 sign-on exit routine.
DSNTIPM-MVS Parameters
- Subsystem Name (SSID) (QWPBSSID) >
- This parameter determines the z/OS® subsystem name for Db2.
- Supress Soft Errors (SUPERRS) (QWP4SAE )
- This parameter determines whether Db2 is recording errors such as invalid decimal data or arithmetic exceptions, and whether SQLCODEs are issued for these errors. These errors are recorded in the operating system data set SYS1.LOGREC.