IBM Support

V 5.3.0: Update to the Report Reference manual, IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Product Documentation


Abstract

Updates that apply to the IBM® Tivoli® OMEGAMON® XE for DB2® Performance Expert on z/OS® and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS Version 5.3.0: Report Reference manual, SH12-7047.

Content

The most recent update is listed first.

*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.



Update 7
Date of change: September 2017
Topics: Multiple
Change description: PTF UI50038 adds a new field, #ROLLUP TRAN to the Accounting report.

See the following PDF for detailed documentation changes:
UI50038.pdfUI50038.pdf



Update 6
Date of change: June 2017
Topics: Multiple
Change description: Chapter 49, “Statistics Report and Trace Blocks”, is updated as indicated in the following PDF:
OMPE-679rr.pdfOMPE-679rr.pdf



Update 5
Date of change: June 2017
Topics: Multiple
Change description: The following two chapters will be updated, to cover information in APAR PI74256:
  • Chapter 40, IFCID Record Blocks
  • Chapter 54, System Parameters Report Blocks


Chapter 40, IFCID Record Blocks:
IFCID 106 - Miscellaneous Installation Parameters
SPT01 MAX 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.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL

Chapter 54, System Parameters Report Blocks
Other System Parameters
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.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL



Update 4
Date of change: February 2017
Topics: Multiple
Change description: The following field descriptions have been updated in the following chapters:
  • Chapter 40. IFCID Record Blocks --> "IFCID 106 - Miscellaneous Installation Parameters"
  • PARALL EFFICIENCY
    The parallelism efficiency factor.
    Note: This field has value of 0 if the System Management Facilities (SMF) trace contains the hexadecimal value X'8000'.
    This field corresponds to field PARALLELISM EFFICIENCY on installation panel DSNTIP8. The ZPARM name is PARA_EFF in DSN6SPRM.
    Field Name: QWP4PAEF

    MAX TAPE UNITS
    The maximum number of tape units or tape drives that the restore system utility can use to restore from a system-level backup that has been dumped to tape.
    A value of 0 is displayed for NOLIMIT.
    Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE_TAPEUNITS in DSN6SPRM.
    Field Name: QWP4RSMT

    MAX REAL+AUX STOR
    The maximum amount of real plus auxiliary storage that can be used.
    A value of 0 is displayed for NOLIMIT.
    The ZPARM name is REALSTORAGE_MAX in DSN6SPRM.
    Field Name: QWP4RSMX


  • Chapter 40. IFCID Record Blocks --> "IFCID 106 - System Initialization Parameters"
  • LEVEL ID CHECKPS
    Shows how often, in checkpoints, the level ID of a page set or partition is updated. When zero (0), down-level detection is disabled. When five (5), down-level is enabled.
    Use the following criteria to decide on a suitable value for this parameter:

    • How often are backup and restore methods used outside of the DB2 control (such as DSN1COPY or DFDSS dump and restore)? If rarely used, there is no need to update the level ID frequently.
    • How many page sets are open for update at the same time? If DB2 updates level IDs frequently, there is extra protection against down-level page sets. However, a performance degradation can occur if the level IDs for many page sets must be set at every checkpoint.
    • How often does the subsystem take checkpoints? If the DB2 subsystem takes frequent system checkpoints, set the level ID frequency to a higher value.

    Install parameter LEVELID UPDATE FREQ on panel DSNTIPL, or ZPARM DLDFREQ in DSN6SYSP.
    Field Name: QWP1DFRQ

  • Chapter 40. IFCID Record Blocks --> "IFCID 106 - Distributed Data Facility Parameters"
  • CONN Q MAX WAIT
    The maximum time that a connection waits for a DBAT request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value is 0.
    A value of 0 is displayed for OFF; a value of 1 is displayed for ON.
    This field corresponds to field CONN QUEUE MAX WAIT on installation panel DSNTIP5. The ZPARM name is MAXCONQW in DSN6FAC.
    Field Name: QWP9MCONQW

    CONN Q MAX DEPTH
    The maximum depth of the connection-request queue of connections that are waiting for a DBAT to process a request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value were 0.
    A value of 0 is displayed for OFF; a value of 32767 is displayed for ON.
    This field corresponds to field CONN QUEUE MAX DEPTH on installation panel DSNTIP5. The ZPARM name is MACONQN in DSN6FAC.
    Field Name: QWP9MCONQN


  • Chapter 54. System Parameters Report Blocks --> "Performance and Optimization (DSNTIP8, DSNTIP81)"
  • PARALL EFFICIENCY
    The parallelism efficiency factor.
    Note: This field has value of 0 if the System Management Facilities (SMF) trace contains the hexadecimal value X'8000'.
    This field corresponds to field PARALLELISM EFFICIENCY on installation panel DSNTIP8. The ZPARM name is PARA_EFF in DSN6SPRM.
    Field Name: QWP4PAEF

  • Chapter 54. System Parameters Report Blocks --> "Log Installation Parameters (DSNTIPL, DSNTIPH)"
  • CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)
    Shows how often, in checkpoints, the level ID of a page set or partition is updated. When zero (0), down-level detection is disabled. When five (5), down-level is enabled.
    Use the following criteria to decide on a suitable value for this parameter:

    • How often are backup and restore methods used outside of the DB2 control (such as DSN1COPY or DFDSS dump and restore)? If rarely used, there is no need to update the level ID frequently.
    • How many page sets are open for update at the same time? If DB2 updates level IDs frequently, there is extra protection against down-level page sets. However, a performance degradation can occur if the level IDs for many page sets must be set at every checkpoint.
    • How often does the subsystem take checkpoints? If the DB2 subsystem takes frequent system checkpoints, set the level ID frequency to a higher value.

    Install parameter LEVELID UPDATE FREQ on panel DSNTIPL, or ZPARM DLDFREQ in DSN6SYSP.
    Field Name: QWP1DFRQ

  • Chapter 54. System Parameters Report Blocks --> "DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)"
  • MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)
    The maximum number of tape units or tape drives that the restore system utility can use to restore from a system-level backup that has been dumped to tape.
    A value of 0 is displayed for NOLIMIT.
    Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE_TAPEUNITS in DSN6SPRM.
    Field Name: QWP4RSMT


  • Chapter 54. System Parameters Report Blocks --> "Distributed Data Facility Panel 2 (DSNTIP5)"
  • CONNECTION QUEUE MAX WAIT (MAXCONQW)
    The maximum time that a connection waits for a DBAT request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value is 0.
    A value of 0 is displayed for OFF; a value of 1 is displayed for ON.
    This field corresponds to field CONN QUEUE MAX WAIT on installation panel DSNTIP5. The ZPARM name is MAXCONQW in DSN6FAC.
    Field Name: QWP9MCONQW

    CONNECTION QUEUE MAX DEPTH (MAXCONQN)
    The maximum depth of the connection-request queue of connections that are waiting for a DBAT to process a request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value were 0.
    A value of 0 is displayed for OFF; a value of 32767 is displayed for ON.
    This field corresponds to field CONN QUEUE MAX DEPTH on installation panel DSNTIP5. The ZPARM name is MACONQN in DSN6FAC.
    Field Name: QWP9MCONQN


  • Chapter 54. System Parameters Report Blocks --> "Storage Sizes Installation Parms (DSNTIPC, DSNTIPE, DSNTIPE1)"
  • MAXIMUM REAL STORAGE (REALSTORAGE_MAX)
    The maximum amount of real plus auxiliary storage that can be used.
    A value of 0 is displayed for NOLIMIT.
    The ZPARM name is REALSTORAGE_MAX in DSN6SPRM.
    Field Name: QWP4RSMX





Update 3
Date of change: April 2016
Topics: Multiple
Change description: The following field descriptions have been updated in:
  • Chapter 40. IFCID Record Blocks --> "IFCID 002 - Accelerator Data - Prior to V4",
    Chapter 40. IFCID Record Blocks --> "IFCID 002 - Accelerator Data - Accelerator Perspective V4 or later",
    Chapter 49. Statistics Report and Trace Blocks --> "Accelerator Data - Prior to Version 4",
    Chapter 49. Statistics Report and Trace Blocks --> "Accelerator Data - Version 4 or later"
  • CURRENT QUEUE LENGTH


    The current queue length at the accelerator.
    Field Name: Q8STCQL

    MAXIMUM QUEUE LENGTH
    The high watermark of the queue length at the accelerator (Field name for
    DB2 Analytics Accelerator for z/OS Version 4: Q8STMAXQ_64).
    Field Name: Q8STMAXQ

    AVG QUEUE WAIT ELAPSED TIME
    The average wait time at the accelerator queue.
    Field Name: Q8STQUEW

    MAX QUEUE WAIT ELAPSED TIME
    The maximum wait time at the accelerator queue.
    Field Name: Q8STQUEM

    AVG QUEUE LENGTH (LAST 3 HRS)
    The average queue length during the last 3 hours at the accelerator.
    Field Name: Q8STAVGQ03

    AVG QUEUE LENGTH (LAST 24 HRS)
    The average queue length during the last 24 hours at the accelerator.
    Field Name: Q8STAVGQ24
  • Chapter 40. IFCID Record Blocks --> "IFCID 225 - IRLM Pool Statistics":

    BTB PRIVATE MAX AVAILABILITY
    The threshold of virtual 31-bit private storage available for normal IRLM execution. Only requests for storage by "must complete" tasks will be granted if this threshold is exceeded.
    Field Name: QW0225I_BPMAX


Update 2
Date of change: October 2015
Topics: Multiple
Change description: PI42687 - The following descriptions have been modified or added in:


Update 1
Date of change: October 2015
Topics: Multiple
Change description: The following description of the system parameters has been modified. New fields are marked in the sample layouts and described in the following text.

Chapter 54. System Parameters Report Blocks:
  • Application Programming Defaults Panel 1 (DSNTIPF)

The new field labels shown in the following sample layout of "System Parameters - Application Programming Defaults Panel 1 (DSNTIPF)" are described in the following section.

APPLICATION PROGRAMMING DEFAULTS PANEL 1 (DSNTIPF)
--------------------------------------------------
DEFAULT HOST LANGUAGE (DEFLANG)..........................IBMCOB
DECIMAL POINT OPTION (DECIMAL)...........................PERIOD
DEFAULT DELIMITER (DELIM)...............................DEFAULT
DEFAULT SQL DELIMITER (SQLDELI).........................DEFAULT
DIST SQL STRING DELIMITER (DSQLDELI)......................APOST
DEFAULT MIXED GRAPHIC (MIXED)................................NO
EBCDIC SBCS CCSID (SCCSID)................................1,140
EBCDIC MBCS CCSID (MCCSID)..................................N/P
EBCDIC GBCS CCSID (GCCSID)..................................N/P
ASCII SBCS CCSID (ASCCSID)..................................437
ASCII MBCS CCSID (AMCCSID)..................................N/P
ASCII GBCS CCSID (AGCCSID)..................................N/P
UNICODE SBCS CCSID (USCCSID)................................367
UNICODE MBCS CCSID (UMCCSID)..............................1,208
UNICODE GBCS CCSID (UGCCSID)..............................1,200
DEFAULT ENCODING SCHEME (ENSCHEME).......................EBCDIC
APPLICATION ENCODING (APPENSCH)..........................EBCDIC
| LOCALE LC_TYPE (LC_CTYPE).................................EN_US
DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_MODE)...ROUND_HALF_EVEN
DEFAULT CHARSET (CHARSET)..............................ALPHANUM

LOCALE LC_CTYPE (LC_TYPE)
The system LOCALE LC_CTYPE. A locale is the part of the system environment that depends on language and cultural conventions. An LC_TYPE is a subset of a locale that applies to character functions. The UPPER, LOWER, and TRANSLATE scalar functions use the CURRENT LOCALE LC_CTYPE system default or special register. The results of these functions can vary, depending on the setting of the locale.
The following values are possible:
BLANK
The source field is empty.This is the default, unless it is necessary to run the UPPER, LOWER, or TRANSLATE functions for data that must be interpreted using the rules provided by specific locales, for example, En_US or Fr_CA.
1st word
The source field contains left-justified word(s), where each byte of a word is > X'40'. It can be a single word or several ones, delimited by bytes <= X'40'.
Note: These hexadecimal codes do not represent printable characters.
N/P
The source field contains regular words that are not left-justified. This means that the first bytes are <= X'40'. N/P is also shown if the whole source field only consists of bytes < X'40', such as zeros.
Install parameter LOCALE LC_CTYPE on panel DSNTIPF, or ZPARM LC_TYPE in DSNHDECP.
Field Name: QWPBLCTP
  • Application Programming Defaults Panel 2 (DSNTIP4, DSNTIP41)
The new field labels shown in the following sample layout of "System Parameters - Application Programming Defaults Panel 2 (DSNTIP4, DSNTIP41)" are described in the following section.
APPLICATION PROGRAMMING DEFAULTS PANEL 2 (DSNTIP4,DSNTIP41)
---------------------------------------------------------------
MINIMUM DIVIDE SCALE (DECDIV3)...............................NO
DECIMAL ARITHMETIC (DECARTH)..............................DEC15
USE FOR DYNAMIC RULES (DYNRULS).............................YES
STATIC DESCRIBE (DESCSTAT)..................................YES
DATE FORMAT (DATE)..........................................ISO
TIME FORMAT (TIME)..........................................ISO
LOCAL DATE LENGTH (DATELEN).................................N/A
LOCAL TIME LENGTH (TIMELEN).................................N/A
IMPLICIT TIMEZONE.......................................CURRENT
STD SQL LANGUAGE (STDSQL)....................................NO
PAD NULL-TERMINATED (PADNTSTR)...............................NO
APPL COMPAT LEVEL (APPLCOMPAT)..............................N/A
LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT).........N/A
| FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE...................
SYS1.DSNEXIT(DSNHDECP)

FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE
Shows the fully qualified DECP name of the data set from which the DSNHDECP module was loaded.
Field Name: QWPBLNM
  • Buffer Pool Parameters (DSNTIP1)

The field labels shown in the following sample layout of "System Parameters - Buffer Pool Parameters (DSNTIP1)" are described in the following section.

BUFFER POOL PARAMETERS (DSNTIP1)
--------------------------------
DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP2
DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
| DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP0
| DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP3

DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)
The name of the buffer pool that is used for implicitly created LOB table spaces. This field corresponds to field default buffer pool for USER LOB DATA on installation panel DSNTIP1. The ZPARM name is TBSBPLOB in DSN6SYSP.
Field Name: QWP1TPLB

DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML)
The name of the buffer pool that is used for XML table spaces. This field corresponds to field default buffer pool for USER XML DATA on installation panel DSNTIP1. The ZPARM name is TBSBPXML in DSN6SYSP.
Field Name: QWP1TPXM
  • DB2 Catalog and Directory Panel (DSNTIPA2) -> new

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)
Enables the compression of SPT01.
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
  • DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)

The field labels shown in the following sample layout of "System Parameters - DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)" are described in the following section.

DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
----------------------------------------------------
TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
| UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
STATISTICS HISTORY (STATHIST)..............................NONE
STATISTICS ROLLUP (STATROLL)................................YES
UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
| UT SORT DATA SET ALLOCATION (UTSORTAL)......................YES
| IGNORE SORTNUM STMT (IGNSORTN)..............................YES
| SET CHECK PENDING (CHECK_SETCHKP)............................NO
| UT DB2 SORT USE (DB2SORT)....................................NO
TEMPLATE TIME (TEMPLATE_TIME)...............................N/A
MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL).......N/A
| FAST REPLICATION (CHECK_FASTREPLICATION)...............REQUIRED
| FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
| FLASHCOPY PPRC (FLASHCOPY_PPRC).............................N/P
DEFAULT TEMPLATE (FCCOPYDDN)...................................
HLQ.&DB..&SN..N&DSNUM..&UQ.
| FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
| FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
| FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
| FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
| FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
REORG PART SORT NPSI (REORG_PART_SORT_NPSI).................N/A
REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/A
REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS).................N/A
REORG IGNORE FREE SPACE (REORG_IGNORE_FREESPACE).............NO
UTILITY CACHE OPTION (SEQPRES)..............................YES
STATISTICS CLUSTERING (STATCLUS).......................ENHANCED

UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS)
Specifies the name of the SMS storage class that DB2 uses for defining temporary shadow data sets. A blank value indicates that the temporary shadow data sets a defined in the same storage class as the production page set. This field corresponds to field "UTIL TEMP STORCLAS" on installation panel DSNTIP6. The ZPARM name is UTIL_TEMP_STORCLAS in DSN6SPRM.
Field Name: QWP4CHEC

UT SORT DATA SET ALLOCATION (UTSORTAL)
YES indicates that utilities invoke a SORT use and a space prediction algorithm for dynamically allocated SORT work data sets. The ZPARM name is UTSORTAL in DSN6SPRM.
Field Name: QWP4SRAL

IGNORE SORTNUM STMT (IGNSORTN)
Ignores SORTNUM clause in utility control statements. The ZPARM name is IGNSORTN in DSN6SPRM.
Field Name: QWP4IGSN

SET CHECK PENDING (CHECK_SETCHKP)
YES sets the object in check-pending status when the check utility detects an inconsistency. This field corresponds to field "Set check pending" on installation panel DSNTIP61. The ZPARM name is CHECK_SETCHKP in DSN6SPRM.
Field Name: QWP4CSCP

UT DB2 SORT USE (DB2SORT)
Enables the use of DB2 SORT.
Field Name: QWP4DB2SRT

FAST REPLICATION (CHECK_FASTREPLICATION)
The FASTREPLICATION type for check utilities:
0
FASTREPLICATION (preferred)
1
FASTREPLICATION (required).

This field corresponds to field "Fast replication" in installation panel DSNTIP6. The ZPARM name is CHECK_FASTREPLICATION in DSN6SPRM.
Field Name: QWP4CFRP

FAST RESTORE (REC_FASTREPLICATION)
Specifies how the Recover utility directs DFSMSdss copy to restore an image copy that was created with FLASHCOPY. This field corresponds to field "Fast restore" on installation panel DSNTIP6. The ZPARM name is REC_FASTREPLICATION.
Field Name: QWP4RFRP

FLASHCOPY PPRC (FLASHCOPY_PPRC)
Specifies the behavior for DFSMSdss FLASHCOPY requests when the target disk storage volume is the primary device in a peer-to-peer remote copy (metro mirror) relationship (DB2 field: QWP4FCPPRC). This field corresponds to field "FLASHCOPY PPRC" on installation panel DSNTIP6. The ZPARM name is FLASHCOPY_PPRC.
Field Name: QWP4FCPPRC

FLASHCOPY COPY (FLASHCOPY_COPY)
YES indicates that the Copy utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when those keywords are not present in the utility control statement. The ZPARM name is FLASHCOPY_COPY in DSN6SPRM.
Field Name: QWP4FCCP

FLASHCOPY LOAD (FLASHCOPY_LOAD)
YES indicates that the load utility uses the subsystem parameter settings for FLASHCOPY, FCCOPYDD, and FCAUXOBJS when those keywords are not present in the utility control statement. ZPARM NAME: FLASHCOPY_LOAD IN DSN6SPRM.
Field Name: QWP4FCLD

FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)
YES indicates that the Reorg Tablespace utility uses the subsystem parameter settings for FLASHCOPY, FCCOPYDDN, and FCAUXOBJS when these keywords are not present in the utility control statement. The ZPARM name is FLASHCOPY_REORG_TS in DSN6SPRM.
Field Name: QWP4FCROT

FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)
YES indicates that the Rebuild Index utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when those keywords are not present in the utility control statement (DB2 field: QWP4FCRBI). The ZPARM name is FLASHCOPY_REBUILD_INDEX in DSN6SPRM.
Field Name: QWP4FCRBI

FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)
YES indicates that the Reorg Index utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when these keywords are not present in the utility control statement (DB2 field: QWP4FCROI). The ZPARM name is FLASHCOPY_REORG_INDEX in DSN6SPRM.
Field Name: QWP4FCROI
  • DB2 Version Install (DSNTIPA1)

The field labels shown in the following sample layout of "System Parameters - DB2 Version Install (DSNTIPA1)" are described in the following section.

DB2 VERSION INSTALL (DSNTIPA1)
------------------------------
DATA SHARING ENABLED (DSHARE)...............................YES
| CURRENT DB2 RELEASE (NEWFUN).................................NO
| CURRENT DB2 RELEASE - 1.....................................YES
| CURRENT DB2 RELEASE - 2......................................NO

CURRENT DB2 RELEASE (NEWFUN)
If YES, the DB2 subsystem/group is running in New Function Mode. At this mode/catalog level, the New Function Mode is enabled and available. The DB2 catalog is completely Unicode (UTF-8) and long names can be used.
Install parameter INSTALL TYPE on panel DSNTIPA1, or ZPARM NEWFUN in DSNHDECP.
Field Name: QWPBNEWF

CURRENT DB2 RELEASE - 1
Shows the current release minus one of the new-function mode (NEWFUN).
Field Name: QWPBNEWFN1

CURRENT DB2 RELEASE - 2
Shows the current release minus two of the new-function mode (NEWFUN).
Field Name: QWPBNEWFN2
  • Define Group or Member (DSNTIPK)

The field labels shown in the following sample layout of "System Parameters - Define Group or Member (DSNTIPK)" are described in the following section.

DEFINE GROUP OR MEMBER (DSNTIPK)
--------------------------------
GROUP NAME (GRPNAME)....................................DSNDBPG
MEMBER NAME (MEMBNAME).....................................DBP0
| MAX NUMBER OF MEMBERS.......................................248
| RANDOM ATTACH (RANDOMATT)...................................YES
DEL CF STRUCTS (DEL_CFSTRUCTS_ON_RESTART)....................NO
PARALLELISM ASSISTANT (ASSIST)...............................NO
PARALLELISM COORDINATOR (COORDNTR)...........................NO

MAX NUMBER OF MEMBERS
The maximum number of members possible in a data sharing group. This is a constant (248) and is not shown on any installation panel.
Field Name: QWPAMAXM

RANDOM ATTACH (RANDOMATT)
Specifies a random group attach flag:
N
Not eligible for random group attach.
NOT N
Eligible for random group attach.
This field corresponds to field RANDOM ATTACH on installation panel DSNTIPK. The ZPARM name is RANDOMATT in DSN6GRP.
Field Name: QWPARAND
  • Distributed Data Facility Panel 1 (DSNTIPR)

The field labels shown in the following sample layout of "System Parameters - Distributed Data Facility Panel 1 (DSNTIPR)" are described in the following section.

DISTRIBUTED DATA FACILITY PANEL 1 (DSNTIPR)
-------------------------------------------
| FACILITY NAME...............................................DDF
DDF STARTUP OPTION (DDF)...................................AUTO
RLST ACCESS ERROR (RLFERRD).............................NOLIMIT
RESYNCHRONIZATION INTERVAL IN MINUTES (RESYNC)................2
DBAT STATUS (CMTSTAT)..................................INACTIVE
MAX TYPE 1 INACTIVE THREADS (MAXTYPE1)........................0
IDLE THREAD TIMEOUT INTERVAL (IDTHTOIN)...................1,800
EXTENDED SECURITY (EXTSEC)..................................YES
| USER ID AND PASSWORD REQUIRED................................NO
| SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
| PRIVATE PROTOCOL (PRIVATE_PROTOCOL)........................AUTH

FACILITY NAME
The name of the DDF facility.
Field Name: QWP9NAME

USER ID AND PASSWORD REQUIRED
Shows whether user ID and password are required. In addition, one of the following is required:
  • The user ID and password and any RACF® PassTickets (A PassTicket is a one-time-only password that is generated by a requesting product or function) are Advanced Encryption Standard (AES) encrypted.
  • A Kerberos ticket is required.
  • The connection is protected by a z/OS® Communications Server IP Application Transparent Transport Layer Security (AT-TLS) policy, which is ensured through a DB2® SECPORT.
  • The connection is protected by an IPSec tunnel.
Field Name: QWP9TCPVE

SQL INTERRUPT PROCESSING DISABLED (SQLINTRP)
Shows how SQL interrupts are processed. It can have the following values:
NO
SQL interrupt processing is enabled.
YES
DB2 SQL interrupt support is disabled.
Note: YES should only be used if remote client systems experience failures because of SQL interrupts. In this case, SQL interrupt support should be disabled only until the remote client systems can be modified to tolerate SQL interrupts.
ZPARM name SQLINTRP in DSN6FAC.
Field Name: QWP9SINTD

PRIVATE PROTOCOL (PRIVATE_PROTOCOL)
Shows if it is allowed to use the private protocol. It can have the following values:
YES
Allows private-protocol-related plan-owner-based package authorization behavior. Plan-owner-based package execution authorization semantics are honored for DB2 for z/OS DRDA® requester systems that might rely on it. Secondary IDs are not used to determine package execution privileges for remote DB2 for z/OS applications.
NO
Does not allow any private-protocol-related behavior. Plan-owner-based package execution authorization semantics are not honored. This might affect DB2 for z/OS DRDA requester systems that rely on it. Secondary IDs are used to determine package execution privileges for remote DB2 for z/OS applications.
ZPARM name PRIVATE_PROTOCOL in DSN6FAC.
Field Name: QWP9PRVPA
  • IRLM Installation Parameters (DSNTIPI)

The field labels shown in the following sample layout of "System Parameters - IRLM Installation Parameters (DSNTIPI)" are described in the following section.

IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------
IRLM SUBSYSTEM NAME (IRLMSID)..............................DJP0
IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)..................120
IRLM AUTOMATIC START (IRLMAUT)..............................YES
IRLM START PROCEDURE NAME (IRLMPRC)....................DBP0IRLM
SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............300
U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK).......NO
X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT)................YES
IMS/BMP TIMEOUT FACTOR (BMPTOUT)..............................4
IMS/DLI TIMEOUT FACTOR (DLITOUT)..............................6
WAIT FOR RETAINED LOCKS (RETLWAIT)............................0
ENABLE DB CHECKING...........................................NO
| IRLM INITIALIZATION TIME......................................1

IRLM INITIALIZATION TIME
The IRLM wait time in seconds.
DB2 autostart abends if IRLM does not start within this time.
Install parameter TIME TO AUTOSTART on panel DSNTIPI, or ZPARM IRLMSWT in DSN6SPRM.
Field Name: QWP4ISWT
  • Other System Parameters

The field labels shown in the following sample layout of "System Parameters - Other System Parameters" are described in the following section.

OTHER SYSTEM PARAMETERS
-----------------------
DUAL BSDS MODE (TWOBSDS)....................................YES
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0
OFFLOAD OPTION (OFFLOAD)....................................YES
SU CONVERSION FACTOR........................................211
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE
STAR JOIN THRESHOLD (SJTABLES)...............................10
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P
ONLINE SYSTEM PARM TIME CHANGED.............................N/P
ONLINE SYSTEM PARM TYPE.....................................N/P
DB2-SUPPLIED DECP INDICATOR...............................X'D5'
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL).............1
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................YES
ZOSMETRICS..................................................YES
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD)......................NO
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX).....................NO
DDF COMPATIBILITY (DDF_COMPATIBILITY).......................N/A
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A
| ACTIVATE I/O SCHEDULING.....................................YES
| VALUE FOR TRIGGER DRAIN.......................................1
| MAX NUMBER OF DDS WITH HOLD...................................3
| FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5
| RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO
| SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960
| SPACE RESERVED FOR CRITICAL WORK.....................91,815,936
| SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....91,815,936
| DETAILED MEASURED UNIT PRICE TRACKING........................NO
| OTC LICENSE TERMS ACCEPTED...................................NO
| SIMULATED CPUS................................................0
| EXECUTION TIME OF TASK/SRB IN MICROSECONDS....................0
| MAX 'NOT FOUND' HASH RECORDS................................100
| MAX EXTEND SERVICE TASKS.....................................20
| PROJECT Z INSERTION THRESHOLD.................................2
| MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096
| REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION................NO
| DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES
| PC YES SPECIFIED............................................YES
| BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO
SMS DATACLASS NAME FOR TS (SMSDCFL).........................N/P (Prior to DB2 11)
SMS DATACLASS NAME FOR IS (SMSDCIX).........................N/P (Prior to DB2 11)
OUTER JOIN PERFORMANCE ENHANCEMENTS (OJPERFEH)..............YES (Prior to DB2 11)

ACTIVATE I/O SCHEDULING
Determines whether the I/O scheduling feature is activated. DB2 parameter SPRMIOP in DSN6SPRM.
Field Name: QWP4IOP

VALUE FOR TRIGGER DRAIN
The percentage below 100% DSMAX that open data sets can reach before an asynchronous drain is started. The default is 1, meaning that asynchronous drain starts when the number of open data sets reaches 99% of DSMAX.
DB2 defers closing and deallocating the table spaces or indexes until the number of open data sets reaches one of the following limits:
  • The MVS limit for the number of concurrently open data sets.
  • 99% (default) of the value that you specified for DSMAX.
When one of these limits is reached, DB2 closes a number of data sets not in use equal to 3% (default) of the value DSMAX. Thus, DSMAX controls not only the limit of open data sets, but also the number of data sets that are closed when that limit is reached.
DB2 parameter SPRMTDD in DSN6SPRM.
Field Name: QWP4TDDN

MAX NUMBER OF DDS WITH HOLD
The percentage of maximum open data sets until the asynchronous drain operations are stopped.
DB2 parameter SPRMMDD in DSNDSPRM.
Field Name: QWP4MDDN

FIELD PROCS FOR DESCRIBE TABLE BLOCK
The number of field procedures for the DESCRIBE TABLE block.
ZPARM SPRMFDP.
Field Name: QWP4FDP

RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC)
A value of YES prevents the use of ALTER table ALTER column with SET DATA TYPE, SET DEFAULT, and DROP DEFAULT when data capture changes is enabled on the target table. The ZPARM name is RESTRICT_ALT_COL_FOR_DCC in DSN6SPRM.
Field Name: QWP4RACD

SPACE RESERVED FOR Z/OS FUNCTIONS
The amount of space reserved for MVS functions.
Field Name: QWP1DB1M

SPACE RESERVED FOR CRITICAL WORK
The amount of space reserved for critical work that must be completed.
Field Name: QWP1CRIT

SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE
The amount of space above z/OS and critical (QWP1DB1M + QWP1CRIT) that DB2 tries to leave available.
Field Name: QWP1SOS

DETAILED MEASURED UNIT PRICE TRACKING
Specifies whether DB2® performs detailed tracking for measured usage pricing. You can select the following values:
YES
DB2 does detailed measured usage tracking if SMF type 89 records are activated. When SMF89 is set to YES, DB2 invokes a z/OS® service on every entry into or exit out of DB2 to ensure accurate tracking.
NO (the default value)
DB2 does not do detailed measured usage tracking. If the SMF type 89 record is activated, only high-level tracking is recorded in the SMF type 89 record. Selecting NO reduces CPU usage, but also increases the amount of time spent in DB2 as measured by SMF 89.
Note: Select SMF89 YES only if you use measured usage pricing.
DB2 parameter SMF89.
Field Name: QWP1SM89

OTC LICENSE TERMS ACCEPTED
Indicates that the one-time charge (OTC) license terms are accepted for this DB2 installation.
DB2 parameter OTC_LICENSE.
Field Name: QWP1OLAC

SIMULATED CPUS
The number of CPUs that are online.
Field Name: QWP4NCPU

EXECUTION TIME OF TASK/SRB IN MICROSECONDS
The accumulated SRB time for the address space. This value includes both, the preemptable and nonpreemptable SRB time. It does not include CPU time that is consumed on an IBM zIIP.
Field Name: QWSASRBT

MAX EXTEND SERVICE TASKS
Maximum number of extended service tasks.
Field Name: QWP4EST

PROJECT Z INSERTION THRESHOLD
Project z insertion threshold.
Field Name: QWP4ZTN

MAX ZIVLEMPEL DICTIONARY ENTRIES
The maximum number of ZIVLEMPEL dictionary entries.
Field Name: QWP4MDE

REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION
Indicates that KEEPDICTIONARY is used when a REORG converts a table space from basic row format (BRF) to reordered row format (RRF).
Field Name: QWP4HKEEPD

DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS)
YES means that in SQL statements, DB2 replaces aliases that refer to three-part names with qualified object names before it sends the statements to the remote location. This substitution is done in the following cases:
  • When PREPARE or EXECUTE IMMEDIATE is performed
  • When REMOTE BIND of a package is performed.
ZPARM name DRDA_RESOLVE_ALIAS in DSN6SPRM.
Field Name: QWP4RSLV

PC YES SPECIFIED
Shows whether the IRLM uses the cross-address-space program call. This parameter determines where the IRLM lock control block structure is stored.
If you run a tightly-controlled environment and virtual storage is not constrained, use PC=NO. PC=YES is the conservative choice where insufficient information about the environment is available to make a well-informed decision.
With PC=NO, locks are managed in extended common service area (ECSA) and it is possible to achieve better CPU performance, because DB2 does not use cross-memory services for IRLM requests. However, ECSA is a limited resource and constrains the size of the private address space area available above the 16-MB line. The demand for ECSA storage to support locks may be excessive when one or more of the following conditions are true:
  • Extensive use of row-level locking
  • Ineffective lock avoidance
  • Infrequent application commits
  • Lock escalation via NUMLKTS and LOCKMAX is disabled because the applications cannot tolerate the impact
  • Effectively no limit on the number of locks taken by an application (NUMLKUS is set very high)
  • Multiple DB2 subsystems with IRLM PC=NO reside on the same z/OS image
Assuming the average lock consumes 536 bytes of storage, a single application which takes 100000 locks before a commit would consume almost 52 MB of ECSA when IRLM is configured with PC=NO. MAXCSA would have to be set to at least 52 MB. If a very large number of locks are held by concurrent application processes, the demand for ECSA may not be able to be supported.
Recommendation: If you run applications that have many of the above characteristics, it is strongly recommended to use PC=YES. Certain ERP vendor applications that run concurrent processes can acquire a very large number of held locks that would require a very large setting for MAXCSA, or cause an ECSA overflow which would adversely impact the availability of the z/OS image.
If PC=NO is selected, MAXCSA should be sized to support the concurrent number of held locks required and to avoid an ECSA overflow condition. When setting MAXCSA, check to ensure that the ECSA setting in PARMLIB is sufficient to support the aggregate demand from IRLM and other subsystems. The ECSA size for z/OS is specified by the CSA keyword in the IEASSYSnn member in SYS1.PARMLIB.
With PC=YES, locks are managed in the extended private area of the IRLM address space. This can increase the CPU cost of lock and unlock requests relative to PC=NO. However, with reasonable lock avoidance, the total CPU overhead is likely to be limited to 1 to 2%, which is well within measurement noise and therefore not significant.
With PC=YES, the MAXIMUM ECSA option is ignored but must not be zero. The amount of storage allowed for LOCK usage is determined from the extended storage provided to the IRLM address space at startup time. This amount is reduced by 200 MB to allow a buffer for IRLM and z/OS required storage and for DMBS MUST COMPLETE processes. The amount being monitored can be seen in the display message from the irlmproc,STATUS,STOR command. IRLM still uses CSA and ECSA for other purposes. If you need to create a dump for DB2 diagnostic purposes, you need to ensure that IRLM is included in the dump, and that the dump data sets are large enough to hold IRLM.
PC=NO is a good solution when one or more of the following conditions are true, particularly when running a data sharing configuration:
  • Optimal CPU performance is required
  • No constraint is necessary on available ECSA
  • Significant IRLM lock contention and a very large number of lock requests with ineffective lock avoidance
  • Relatively high IRLM SRB time
YES puts the lock control block structure in the IRLM private address space, and the program call instruction is used to address it. IRLM still uses CSA and ECSA for other purposes. With PC=YES, the MAXIMUM ECSA option is ignored.
Field Name: QWP5PCY

BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)
YES indicates that sort access paths are disabled (if possible) if OPTIMIZE for 1 row with a query is used. If a possible access path avoids a SORT, DB2 chooses this access path.
ZPARM name is OPT1ROWBLOCKSORT in DSN6SPRM.
Field Name: QWP4O1RBS
  • Performance and Optimization (DSNTIP8, DSNTIP81)

The field labels shown in the following sample layout of "System Parameters - Performance and Optimization (DSNTIP8, DSNTIP81)" are described in the following section.

   PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81)                
   -----------------------------------------------                
   CACHE DYNAMIC SQL (CACHEDYN)................................YES
   OPTIMIZATION HINTS ALLOWED (OPTHINTS).......................YES
   EVALUATE UNCOMMITTED (EVALUNC)...............................NO
   SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO
   IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO
   REBIND PLANMGMT DEFAULT (PLANMGMT)..........................OFF
   PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC
   PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................N/A
   RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO
 | DISABLE EDM RTS (DISABLE_EDMRTS)............................YES
   CURRENT DEGREE (CDSSRDEF)...................................ANY
   MAX DEGREE OF PARALLELISM (PARAMDEG)..........................4
   MAX DEGREE FOR DPSI (PARAMDEG_DPSI).........................N/A
 | PARALLELISM EFFICIENCY (PARA_EFF)............................50
   STAR JOIN ENABLING (STARJOIN) ..........................DISABLE
   MAX DATA CACHING IN MB (MXDTCACH)............................20
   CURRENT REFRESH AGE (REFSHAGE)................................0
   CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM
   VARCHAR FROM INDEX (RETVLCFK)................................NO

DISABLE EDM RTS (DISABLE_EDMRTS)
Hexadecimal (X'01'). YES disables the use of EDM real-time Statistics. The ZPARM name is DISABLE_EDMRTS in DSN6SPRM.
Field Name: QWP4DEDR

PARALLELISM EFFICIENCY (PARA_EFF)
The parallelism efficiency factor. This field corresponds to field "Parallelism efficiency" on installation panel DSNTIP8. The ZPARM name is PARA_EFF in DSN6SPRM.
Field Name: QWP4PAEF
  • Routine Parameters (DSNTIPX)

The field labels shown in the following sample layout of "System Parameters - Routine Parameters (DSNTIPX)" are described in the following section.

ROUTINE PARAMETERS (DSNTIPX)
----------------------------
MAX ABEND COUNT (STORMXAB)....................................0
TIMEOUT VALUE (STORTIME)....................................180
WLM ENVIRONMENT (WLMENV)...............................DBPGD800
MAX OPEN CURSORS (MAX_NUM_CUR)..............................500
MAX STORED PROCS (MAX_ST_PROC)............................2,000
MAXIMUM NUMBER OF LE TOKENS (LEMAX)..........................20
| BIF COMPATIBILITY (BIF_COMPATIBILITY)........V9_DECIMAL_VARCHAR

BIF COMPATIBILITY (BIF_COMPATIBILITY)
Specifies whether the character built-in function (BIF) returns results for decimal input in DB2 9.1 for z/OS format or in the format of the current DB2 version. This field corresponds to field BIF COMPATIBILITY on installation panel DSNTIPX.
ZPARM name BIF_COMPATIBILITY in DSN6SPRM.
Field Name: QWP4_BIF_COMPAT

  • Sizes Panel 1 (DSNTIPD)
The field labels shown in the following sample layout of "System Parameters - Sizes Panel 1 (DSNTIPD)" are described in the following section.

SIZES PANEL 1 (DSNTIPD)
-----------------------
| LOB INLINE LENGTH (LOB_INLINE_LENGTH).........................0
USER LOB VALUE STORAGE IN KB (LOBVALA)..................200,000
SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................16,384
USER XML VALUE STG IN KB (XMLVALA)......................204,800
SYSTEM XML VAL STG IN MB (XMLVALS).......................10,240

LOB INLINE LENGTH (LOB_INLINE_LENGTH)
Default inline length for any new storing large object (LOB) column in a Universal Table Space on the DB2 subsystem. The valid values are from 0 to 32680 inclusive (in bytes). The default value for this ZPARM is 0, which indicates that no inline attribute is desired for any LOB column (BLOB, CLOB or DBCLOB) created on this subsystem.
Field Name: QWP1LBIL
  • SQL Object Defaults Panel (DSNTIP7, DSNTIP71)

The field labels shown in the following sample layout of "System Parameters - SQL Object Defaults Panel (DSNTIP7, DSNTIP71)" are described in the following section.

SQL OBJECT DEFAULTS PANEL (DSNTIP7,DSNTIP71)
--------------------------------------------
| REORDERED ROW FORMAT (RRF)..................................YES
OBJECT CREATE FORMAT (OBJECT_CREATE_FORMAT).................N/A
UTILITY OBJECT CONVERSION (UTILITY_OBJECT_CONVERSION).......N/A
VARY DS CONTROL INTERVAL (DSVCI)............................YES
TABLE SPACE ALLOCATION IN KB (TSQTY)..........................3
INDEX SPACE ALLOCATION IN KB (IXQTY)..........................0
OPTIMIZE EXTENT SIZING (MGEXTSZ)............................YES
PAD INDEX BY DEFAULT (PADIX).................................NO
DEFAULT PARTITION SEGSIZE (DPSEGSZ)..........................32
PERCENT FREE FOR UPDATE (PCTFREE_UPD).......................N/A
DEFINE DATA SETS (IMPDSDEF).................................YES
USE DATA COMPRESSION (IMPTSCMP)..............................NO
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)............NO

REORDERED ROW FORMAT (RRF)
A value of YES shows that reordered row format is enabled.
This field corresponds to field REORDERED ROW FORMAT on installation panel DSNTIP7. The ZPARM name is RRF in DSN6SPRM.
Field Name: QWP4RRF

  • Storage Sizes Installation Parms (DSNTIPC, DSNTIPE, DSNTIPE1)

The field labels shown in the following sample layout of "System Parameters - Storage Sizes Installation Parms (DSNTIPC, DSNTIPE, DSNTIPE1)" are described in the following section.

STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1)
---------------------------------------------------------------
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX).........100,000
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)...............960,000
EDM DBD CACHE SIZE IN KB (EDMDBDC)......................136,771
EDM SKELETON POOL SIZE IN KB (EDM_SKELETON_POOL).........24,000
MAXIMUM SIZE OF EDM POOL IN BYTES (EDMPOOL)..........52,428,800
MAXIMUM SIZE OF SORT POOL IN BYTES (SRTPOOL).........40,960,000
MAX IN-MEMORY SORT SIZE (MAXSORT_IN_MEMORY).................N/A
MAXIMUM SIZE OF RID POOL IN KB (MAXRBLK)................200,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......800
MAX NO OF CONCURRENT REMOTE ACTIVE CONNECTIONS (MAXDBAT)....600
MAX NO OF REMOTE CONNECTIONS (CONDBAT)....................1,800
MAX NO OF TSO CONNECTIONS (IDFORE)..........................300
MAX NO OF BATCH CONNECTIONS (IDBACK)........................400
MAXIMUM KEPT DYNAMIC STATEMENTS (MAXKEEPD)................5,000
MAX OPEN FILE REFS (MAXOFILR)...............................100
| MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)...............AUTO
| MAXIMUM REAL STORAGE (REALSTORAGE_MAX)........................0
CONTRACT THREAD STORAGE (CONTSTOR)..........................YES
MANAGE THREAD STORAGE (MINSTOR).............................YES
LONG-RUNNING READER IN MINUTES (LRDRTHLD).....................0
DDL TIMEOUT FACTOR (DDLTOX)...................................1
INDEX CLEANUP THREADS (INDEX_CLEANUP_THREADS)...............N/A
3990 CACHE (SEQCACH)........................................SEQ

MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)
Specifies whether DB2® manages real storage consumption. This field corresponds to field MANAGE REAL STORAGE on installation panel DSNTIPE. The ZPARM name is REALSTORAGE_MANAGEMENT in DSN6SPRM.
Field Name: QWP4STMN

MAXIMUM REAL STORAGE (REALSTORAGE_MAX)
The maximum amount of real plus auxiliary storage that can be used. The ZPARM name is REALSTORAGE_MAX in DSN6SPRM.
Field Name: QWP4RSMX

  • Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN)

The field labels shown in the following sample layout of "System Parameters - Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN)" are described in the following section.

TRACING, CHECKPOINT & PSEUDO-CLOSE PARAMETERS (DSNTIPN)
-------------------------------------------------------
START AUDIT TRACE (AUDITST)...................................1
START GLOBAL TRACE (TRACSTR).................................NO
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16
| LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16
START SMF ACCOUNTING (SMFACCT)........................1,2,3,7,8
START SMF STATISTICS (SMFSTAT).....................1,3,4,5,6,10
STATISTICS TIME INTERVAL IN MINUTES (STATIME).................1
SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)...........NO
ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)......5
START MONITOR TRACE (MON)....................................NO
MONITOR BUFFER SIZE IN BYTES (MONSIZE)................1,048,576
UNICODE IFCIDS (UIFCIDS).....................................NO
DDF/RRSAF ACCUM (ACCUMACC)...................................20
AGGREGATION FIELDS (ACCUMUID).................................0
COMPRESS SMF RECS (SMFCOMP).................................OFF

LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC)
The size of the local trace tables in multiples of 4 KB. ZPARM name TRACLOC in DSN6SYSP.
Field Name: QWP1TLSZ
  • Workfile Database Panel (DSNTIP91)

The field labels shown in the following sample layout of "System Parameters - Workfile Database Panel (DSNTIP91)" are described in the following section.

WORKFILE DATABASE PANEL (DSNTIP91)
----------------------------------
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)..............25,000
| SEPARATE WORK FILES (WFDBSEP)................................NO
MAX TEMP RID (MAXTEMPS_RID)................................NONE
AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)............N/A
SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)..........N/A

SEPARATE WORK FILES (WFDBSEP)
Hexadecimal (X'01'). YES directs processing of declared temporary tables only to DB2-managed table spaces that are defined with SECQTY>0 (DB2 field: QWP4WFDBSEP). It directs all other processing to DB2-managed table spaces that are defined with SECQTY=0 or to user-managed table spaces. This field corresponds to field "Separate Work Files" in installation panel DSNTIP9. The ZPARM name is WFDBSEP in DSN6SPRM.
Field Name: QWP4WFDBSEP

Publication Number

SH12-7047

Original Publication Date

15 September 2016

Document Location

Worldwide

[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"IBM Tivoli OMEGAMON XE for DB2 PE \/ PM \/ BPA","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"5.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

OMEGAMON XE for DB2 PE;OMEGAMON XE for DB2 PM

Document Information

Modified date:
26 September 2022

UID

swg27045971