IFCID 106 - Miscellaneous Installation Parameters
This topic shows detailed information about "Record Trace - IFCID 106 - Miscellaneous Installation Parameters".
This block shows values that are not shown on DB2 installation panels. These values are either set internally by DB2, or calculated from other install parameter values.
When this block contains names that are too long for the space available, they are truncated. The full name is shown in the list of long names, which is printed at the end of this block. When present, the list shows the parameter identifier, in alphabetic order, and the complete name. If the name is too long for one line, it continues on the next line.
Record trace - IFCID 106 - Miscellaneous Installation Parameters
The field labels shown in the following sample layout of "Record Trace - IFCID 106 - Miscellaneous Installation Parameters" are described in the following section.
MISCELLANEOUS INSTALLATION PARAMETERS
EDM POOL SIZE ...: N/A IRLM PROCEDURE ..: DC11IRLM
TAB OWNER .......: DSNRGCOL INST DD CTRL SUPT: NO IRLM MODULE NAME : IC11
APPL TABLE ......: DSN_REGISTER_APPL CTRL ALL APPLIC .: NO IRLM START TIME .: 120
OBJ TABLE .......: DSN_REGISTER_OBJT REQ FULL NAMES ..: YES IRLM INIT TIME ..: 1
INSTALL SYSADM ..: LOGO UNREGIST DDL DFLT: ACCEPT IRLM AUTOSTART ..: YES
SYSADM ID 2 .....: SYSADM UTILITY FACTOR ..: 6 IRLM TIMEOUT ....: 30
DEFAULT USERID ..: IBMUSER EXPL AT AUTOBIND : YES MAXIMUM DATASETS : 20000
DATABASE NAME ...: DSNRGFDB ENABLE DATA CAPT : NO ASYNC DRAIN START: 1
SYSOPER ID ......: LOGO SITE TYPE .......: LOCAL ASYNC DRAIN STOP : 3
SYSOPER ID 2 ....: EMIL TRACKER SITE ....: NO ENFORCE DPROP ...: NO
DDCS ESCAPE CHAR : 'BLANK' WAIT RETAIN LOCKS: NO IMS/BMP TIMEOUT .: 4
BIND NEW PACKAGE : BINDADD AUTO BIND .......: YES IMS/DLI TIMEOUT .: 6
ENABLE DB2 AUTH .: YES MAX APPL LOCKS ..: 10000 CACHE DYNAMIC SQL: YES
AUTH CACHE SIZE .: 3072 REP READ U LOCK .: YES MAX KEPT DYN STMT: 5000
ACCEL MODELING ..: NO MAX TSPACE LOCK .: 2000 CURRENT DEGREE ..: 1
OPT HINTS ALLOWED: NO SORT POOL SIZE ..: 10240000 STATIC DESCRIBE .: YES
RIDPOOL SIZE (KB): 400000 PACK AUTH CACHE .: 5242880 CONTR THREAD STOR: YES
MAX DEG OF PARALL: 0 RTN AUTH W/O CAT : 5242880
USE X LOCK ......: NO STAR JOIN ENABL .: DISABLE
NPAGES THRESHOLD : 0 DBADM CREATE VIEW: NO MAX # LE TOKENS .: 20
MAX EXT SERV TASK: 20 PROJ Z INS THRESH: 2
MAX NOT FOUND-HSH: 100 FIELD PROCS T BLK: 5 MANAGE THREAD STO: NO
EVAL UNCOMMITTED : NO STATISTICS ROLLUP: YES STATISTICS HIST .: NONE
SUPPRESS SOFT ERR: YES REAL TIME STATS .: 30 EDM STATMNT CACHE: 116107264
STAR JOIN THRESH : 10 ZOSMETRICS ......: YES EDM DBD CACHE ...: 23961600
LONG RUNNING READ: 10 MAX OPEN CURSORS : 500 EDM SKEL POOLSIZE: 10485760
CUR MAINT TYPE ..: SYSTEM PAD IDX BY DEFLT : NO MIN DIVIDE SCALE : NONE
FREE CACHED STMTS: 1 TEMP UNIT NAME ..: SYSDA CUR REFRESH AGE .: 0
MAX DATA CACHING : 20 ONL ZPARM TYPE ..: 'BLANK' RESTORE/RECOVER .: NO
MAX STORED PROCS : 2000 ONL ZPARM USER ID: 'BLANK' INDEX I/O PARALL : YES
MAX TEMP STORAGE : 0 ONL ZPARM CORID .: 'BLANK' REVOKE DEP PRIVIL: SQLSTMT
MAX CONC AUTOBIND: 10 ONL ZPARM TIME ..: N/P
PLANMGMT ........: EXTENDED ADM SCHED JCLPROC: 'BLANK' SYS-LEVEL BACKUP : NO
PLANMGMTSCOPE ...: STATIC DUMP CLASS NAME .: 'BLANK' MAX TAPE UNITS ..: 0
SEPARATE SECURITY: NO SECADM1 ID ......: SECADM SECADM1 TYPE ....: AUTHID
MAX TEMP RID ....: NOLIMIT SECADM2 ID ......: SECADM SECADM2 TYPE ....: AUTHID
SKIP UNCOMM INS .: NO GET ACCEL ARCHIVE: NO LMT CONV PART TAB: YES
DDL TIMEOUT FACT : 1 CUR QUERY ACCEL .: NONE REORG SORT NPSI .: AUTO
MAX UTIL PARALL .: 99 ACCEL STARTUP OPT: NO REORG IGN FREESPC: NO
MULT INDEX ACCESS: YES QUERY ACCEL OPT .: NONE REORG TABSPC LIST: PARALLEL
OPT 1 ROW-NO SORT: NO AUTH EXIT CHECK .: PRIMARY REORG MAPPING DB : 'BLANK'
UTIL OBJ CONVERS : NONE AUTHEX CACHE REF : NONE REORG DROP PARTS : NO
OBJ CREATE FORMAT: EXTENDED PKG RLEASE COMMIT: YES REORG KEEP DICT .: NO
TEMPLATE TIME ...: UTC MAX IN-MEM SORT .: 1000 STATIST FEEDBACK : ALL
MAX PARA DEG DPSI: 0 APPL COMPAT .....: V11R1 PCTFREE UPDATE ..: 0
WF DB AGNT THRESH: 0 LIKE BLANK INSIGN: NO IDX CLEANUP THRDS: 10
WF DB SYS THRESH : 90 D.STMT CACHE STOR: 2 SPT01 MAX LENGTH : 32138
SIMULATED CPUS ..: 0 MSEC OF TASK/SRB : 0 COMPRESS SPT01 ..: NO
UT SORT DS ALLOC : YES MAX ZL DICT ENTR : 4096 I/O SCHEDULING ..: YES
UT DB2 SORT USE .: YES ENABLE DB CHECK .: NO IGN SORTNUM STMT : NO
UT TEMP STORCLASS: 'BLANK' BIF COMPATIBILITY: V9 FAST REPLICATION : REQUIRED
FLASHCOPY PPRC ..: REQUIRED CAT DAT DATACLASS: XVSAM FAST RESTORE ....: PREFERRED
FLASHCOPY COPY ..: NO CAT DAT MGMTCLASS: DB2 RESTR ALT COL DCC: NO
FLASHCOPY LOAD ..: NO CAT DAT STORCLASS: DB2 SET CHECK PENDING: NO
FLASHCOPY REB IX : NO CAT IDX DATACLASS: XVSAM DISABLE EDM RTS .: NO
FLASHCPY REORG TS: NO CAT IDX MGMTCLASS: DB2 DRDA RESOLV ALIAS: YES
FLASHCPY REORG IX: NO CAT IDX STORCLASS: DB2 MANAGE REAL STOR : AUTO
MAX REAL+AUX STOR: 0 PARALL EFFICIENCY: 50 REORDERD ROW FORM: YES
SEPAR WORK FILES : NO PREVENT ALTER LMT: YES PREVENT IDX PART : YES
RETRY STOPPED OBJ: NO EMPTY XML ELEMENT: YES RENAME TABLE : YES
ALTERNATE CPYPOOL: CP1 DB BAK STG GRP : SG1 LOG BAK STG GRP : SG2
COPY FAST REPLIC : PREFERRED PAGE NUMBERING : ABSOLUTE COMPRESS_DIRLOB : NO
CACHE DYN STABIL : BOTH SELECT FOR UNLOAD: YES DDL MATERIALIZATN: ALWAYS_IMMEDIATE
INDEX MEMORY CTRL: AUTO HSM MSG DS HLQ : HSMHLQ DFLT INSERT ALG : 2
STATFDBK PROFILE : YES MAT NODET SQLTUDF: NO
...................
LIST OF LONG NAMES
FCOPY DEFLT TEMPL: DSNC11.&DB..&SN..N&DSNUM..&UQ.
QWP4LEN .........: 2724 QWP4EYE .........: SPRM QWP4LVL .........: DSN1210
QWP4MMRB ........: 408 QWP4WREN ........: 300 QWP4FSTP ........: YES
QWP4MRU .........: YES QWP4BMCK ........: OFF QWP4WIOL ........: ON
QWP4LRNG ........: OFF QWP4SLDB ........: OFF QWP4BYCK ........: OFF
QWP4SLIX ........: OFF QWP4NAPF ........: OFF QWP4CTUP ........: OFF
QWP4DIV3 ........: OFF QWP4EXPL ........: OFF QWP4NHJM ........: OFF
QWP4STOO ........: OFF QWP4UDEG ........: NO QWP4VCOF ........: 2704
QWP4DBOF ........: 2692 QWP4SWFN ........: 140 QWP4SMXN ........: 64000
QWP4BMC1 ........: 10 QWP4BMC2 ........: 20 QWP4SWT1 ........: 5
QWP4SWT2 ........: 40 QWP4DWF1 ........: 14 QWP4DWU1 ........: 8
QWP4DWU2 ........: 8 QWP4VDWT ........: 64 QWP4KDSA ........: 1300
QWP4KDSB ........: 1000 QWP4RDEU ........: 600 QWP4LRUT ........: 4000
QWP4PF32 ........: 0 QWP4PFT1 ........: 14 QWP4PFT2 ........: 10
QWP4BBTR ........: 500 QWP4PSID ........: X'00000000' QWP4DSPM ........: 50
QWP4CHKL ........: 10 QWP4PDQ .........: 128 QWP4PCBS ........: 20
QWP4HRCL ........: ON QWP4PCWH ........: 1 QWP4PCRB ........: 20
QWP4MXRB ........: 20000 QWP4HRCD ........: 120 QWP4RCST ........: 8
QWP4TRWT ........: 10 QWP4WPFQ ........: 4 QWP4WPFS ........: 4
QWP4SQTM ........: 4 QWP4SQTD ........: 5 QWP4VDTM ........: 1
QWP4MPFQ ........: 2 QWP4SWFU ........: 5 QWP4TISP ........: 24576
QWP4DRBS ........: 30720 QWP4RMIN ........: 1 QWP4MXVL ........: NO
QWP4RNLP ........: 8 QWP4RHTI ........: 4 QWP4INTV ........: 120
QWP4QCTM ........: 120 QWP4TXS .........: 24576 QWP4SRBT ........: 10
QWP4AND .........: 32 QWP4OR ..........: 25 QWP4NOIN ........: NO
QWP4CUT .........: 100 QWP4SPC .........: 100
QWP4NLG .........: NO QWP4AST .........: 99 QWP4SCTM ........: 10
QWP4ZUT .........: 2 QWP4ULBZ ........: 10240 QWP4ACAN ........: 10
QWP4COC1 ........: 128 QWP4COC2 ........: 10 QWP4ULFR ........: 1
QWP4IOP .........: ON QWP4DBCK ........: OFF QWP4GOP .........: OFF
QWP4FFB .........: NO QWP4XCTH ........: 0 QWP4UBS .........: 128
QWP4DATE ........: 10/05/15 QWP4AURT ........: 50 QWP4DXTP ........: 2
QWP4MXTB ........: 225 QWP4CTHR ........: 10 QWP4STHR ........: 1048576
QWP4SREC ........: X'8000' QWP4RMTI ........: 1 QWP4MXCE ........: 1023
QWP4INLP ........: 50 QWP4RRBA ........: NO QWP4MQTH ........: 120
QWP4TTRS ........: 1 QWP4MXOS ........: 40 QWP4MXOC ........: 100
QWP4LTDM ........: 10 QWP4URNM ........: YES QWP4PROF ........: NO
QWP4SCLC ........: 255 QWP4UNM7 ........: NO QWP4NLGF ........: NO
QWP4JRCS ........: NO QWP4LRCS ........: NO QWP4IRCS ........: NO
QWP4DMTR ........: 500 QWP4BXTR ........: 500 QWP4LBTR ........: 500
QWP4SCAC ........: YES QWP4PST .........: YES QWP4VCFK ........: NO
QWP4DSCM ........: NO QWP4CDIO ........: NO QWP4OPSE ........: YES
QWP4OJEH ........: YES QWP4DCFS ........: 'BLANK' QWP4DCIX ........: 'BLANK'
QWP4COMC ........: NO QWP4IXIO ........: YES QWP4STCL ........: YES
QWP4QA98 ........: NO QWP4QA99 ........: NO QWP4N4504 .......: NO
QWP4ATRC ........: 500 QWP4MUSE ........: N/P QWP4N2645_1......: NO
QWP4QRWD ........: 1 QWP4N0193A ......: 1024 QWP4N0193B ......: 100
QWP4TRSU ........: YES QWP4FLKT ........: 0 QWP4HAVL ........: NO
QWP4TRSS ........: NO QWP4FLMT ........: 100 QWP4TRCK ........: NO
QWP4FTST ........: NO QWP4FLBS ........: 10 QWP4PJSJ ........: NO
QWP4PLIM ........: 120 QWP4OPTC ........: YES QWP4OXQB ........: YES
QWP4RPTC ........: YES QWP4SMGE ........: NO QWP4MUDI ........: NO
QWP4SELD ........: 0 QWP4DINB ........: NO QWP4EXQRY .......: 13000
QWP4ABVC ........: 2147483647 QWP4APS .........: N/P QWP4SA1X ........: NO
QWP4IAST ........: 4 QWP4RIDNOWF .....: NO QWP4SA2X ........: NO
QWP4PDPN ........: NO QWP4TPXF ........: NO QWP4PDST ........: NO
QWP4PEPT ........: NO QWP4PDCP ........: NO QWP4PELM ........: 1000
QWP4PLMR ........: 100 QWP4IMWF ........: 128 QWP4HASH ........: N/P
QWP4SLD2 ........: NO QWP4PLMS ........: 1000 QWP4GRGL ........: YES
QWP4INLTBL ......: YES QWP4DRGL ........: YES QWP4TBLVMG ......: YES
QWP4EPMH ........: NO QWP4PRDPD .......: YES QWP4KLRU ........: 2
QWP4SLRU ........: 2 QWP4DLRU ........: 2 QWP4DYNPF .......: YES
QWP4NIDX ........: 0 QWP4P1MT ........: NO QWP4TPM .........: NO
QWP4IXMT ........: 0 - EDM POOL SIZE
The size (in kilobytes) of the environmental descriptor manager (EDM) pool.
This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.
Install parameter EDMPOOL STORAGE SIZE on panel DSNTIPC, or ZPARM EDMPOOL in DSN6SPRM.
Field Name: QWP4EDPL
- IRLM PROCEDURE
The name of the IRLM procedure invoked by MVS if AUTO START is YES.
The name cannot be the same as the subsystem name given for SUBSYSTEM NAME.
Install parameter PROC NAME on panel DSNTIPI, or ZPARM IRLMPRC in DSN6SPRM.
Field Name: QWP4IPRC
- TAB OWNER
The owner of the application registration table and the object registration table.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter REGISTRATION OWNER on panel DSNTIPZ, or ZPARM RGFCOLID in DSN6SPRM.
Field Name: QWP4REGC
- INST DD CTRL SUPT
Indicates whether data definition support has been installed.
Install parameter INSTALL DD CONTROL SUPT on panel DSNTIPZ, or ZPARM RGFINSTL in DSN6SPRM.
Field Name: QWP4REGI
- IRLM MODULE NAME
The IRLM subsystem name defined to MVS.
This is used for communication between DB2 and the IRLM. It is included in the MVS subsystem table IEFSSN xx, where xx is the value of SUBSYSTEM MEMBER on installation panel DSNTIPM.
If the IRLM for IMS is installed, the DB2 IRLM name is different because two IRLMs on the same MVS system must have unique names.
Install parameter SUBSYSTEM NAME on panel DSNTIPI, or ZPARM IRLMSID in DSN6SPRM.
Field Name: QWP4ISID
- APPL TABLE
The name of the application registration table.
Install parameter APPL REGISTRATION TABLE on panel DSNTIPZ or ZPARM RGFNMPRT in DSN6SPRM.
Field Name: QWP4REGA
- CTRL ALL APPLIC
Indicates that the DB2 system is completely controlled by a set of closed applications identified in the application registration table.
Closed applications require their DB2 objects to be managed solely through the plans or packages registered in the application registration table.
Install parameter CONTROL ALL APPLICATIONS on panel DSNTIPZ, or ZPARM RGFDEDPL in DSN6SPRM.
Field Name: QWP4REGD
- IRLM START 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
- OBJ TABLE
The name of the object registration table.
Install parameter OBJT REGISTRATION TABLE on panel DSNTIPZ, or ZPARM RGFNMORT in DSN6SPRM.
Field Name: QWP4REGO
- REQ FULL NAMES
Indicates whether registered objects require fully qualified names.
Install parameter REQUIRE FULL NAMES on panel DSNTIPZ, or ZPARM RGFFULLQ in DSN6SPRM.
Field Name: QWP4REGQ
- IRLM INIT TIME
The number of seconds DB2 waits before querying whether IRLM has completed initialization.
DB2 parameter SPRMISWI in DSNMSPRM.
Field Name: QWP4ISWI
- INSTALL SYSADM
One of two authorization IDs with SYSADM authority. SYSADM users can access to DB2 in all cases.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter SYSTEM ADMIN 1 on panel DSNTIPP, or ZPARM SYSADM in DSN6SPRM.
Field Name: QWP4SADM
- UNREGIST DDL DFLT
The action taken for DDL that names an unregistered object.
Options are REJECT, ACCEPT, or APPL, which rejects the DDL when the current application is not registered.
Install parameter UNREGISTERED DDL DEFAULT on panel DSNTIPZ, or ZPARM RGFDEFLT in DSN6SPRM.
Field Name: QWP4REGU
- IRLM AUTOSTART
Indicates whether IRLM is started automatically by DB2.
Install parameter AUTO START on panel DSNTIPI, or ZPARM IRLMAUT in DSN6SPRM.
Field Name: QWP4IAUT
- SYSADM ID 2
One of two authorization IDs with SYSADM authority. SYSADM users can access to DB2 in all cases.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter SYSTEM ADMIN 2 on panel DSNTIPP, or ZPARM SYSADM2 in DSN6SPRM.
Field Name: QWP4ADM2
- UTILITY FACTOR
Shows how much longer utilities can wait for a resource than SQL applications can.
This is the number of RESOURCE TIMEOUT units that a utility or utility command can wait for a lock or for all claims on a resource of a particular claim class to be released. The default value is 6, meaning a utility can wait 6 times longer than an SQL application for a resource.
Install parameter UTILITY TIMEOUT on panel DSNTIPI, or ZPARM UTIMOUT in DSN6SPRM.
Field Name: QWP4UTO
- IRLM TIMEOUT
The number of seconds before a timeout is detected.
This is an integer multiple of DEADLOCK TIME on panel DSNTIPJ.
Timeout means that a lock request has waited for a resource (or for claims on a resource for a particular claim class to be released) longer than this time.
For data sharing, the actual timeout period is longer than the timeout value.
Install parameter RESOURCE TIMEOUT on panel DSNTIPI, or ZPARM IRLMRWT in DSN6SPRM.
Field Name: QWP4TOUT
- DEFAULT USERID
The authorization ID used if RACF is not available for batch access and USER= is not specified in the job statement.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter UNKNOWN AUTHID on panel DSNTIPP, or ZPARM DEFLTID in DSN6SPRM.
Field Name: QWP4DFID
- EXPL AT AUTOBIND
Indicates whether EXPLAIN processing occurs during automatic rebind.
YES means EXPLAIN processing happens during automatic rebind of a plan or package that has EXPLAIN(YES) as a bind option. If the PLAN_TABLE does not exist, automatic rebind continues, but there is no EXPLAIN output. Explain processing does not happen for a plan or package with EXPLAIN(NO).
Install parameter EXPLAIN PROCESSING on panel DSNTIPO, or ZPARM ABEXP in DSN6SPRM.
Field Name: QWP4ABX
- MAXIMUM DATASETS
The maximum number of data sets that can be open at one time.
The practical limit can be less than the MVS limit of 32727, depending on available storage below the line.
Install parameter DSMAX on panel DSNTIPC, or ZPARM DSMAX in DSN6SPRM.
Field Name: QWP4DSMX
- DATABASE NAME
The name of the database that contains the registration tables.
Install parameter REGISTRATION DATABASE on panel DSNTIPZ, or ZPARM RGFDBNAM in DSN6SPRM.
Field Name: QWP4REGN
- ENABLE DATA CAPT
Indicates whether change data capture is enabled.
Install parameter DPROP SUPPORT on panel DSNTIPO. ZPARM name is CHGDC in DSN6SPRM.
Field Name: QWP4CDC
- ASYNC DRAIN START
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
- SYSOPER ID
One of two authorization IDs with SYSOPR authority. SYSOPR users can access DB2 even if the DB2 catalog is unavailable.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter SYSTEM OPERATOR 1 on panel DSNTIPP, or ZPARM SYSOPR1 in DSN6SPRM.
Field Name: QWP4OPR1
- SITE TYPE
Shows whether this system is at a local site or a recovery site.
- LOCALSITE
- This is the site of the current system. Multiple image copies are made and are operational here. This is the default.
- RECOVERYSITE
- This an alternative site for recovery purposes.
The RECOVER utility uses this parameter to determine what site the current system is on and recovers everything from the copies of data registered at that site.
The RECOVER and MERGECOPY utilities use this to determine whether COPYDDN or RECOVERDDN is allowed with NEWCOPY NO.
Install parameter SITE TYPE on panel DSNTIPO, or ZPARM SITETYP in DSN6SPRM.
Field Name: QWP4MSTY
- ASYNC DRAIN STOP
The percentage of maximum open data sets until the asynchronous drain operations are stopped.
DB2 parameter SPRMMDD in DSNDSPRM.
Field Name: QWP4MDDN
- SYSOPER ID 2
One of two authorization IDs with SYSOPR authority. SYSOPR users can access DB2 even if the DB2 catalog is unavailable.
This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.
Install parameter SYSTEM OPERATOR 2 on panel DSNTIPP, or ZPARM SYSOPR2 in DSN6SPRM.
Field Name: QWP4OPR2
- TRACKER SITE
Indicates whether this subsystem is a remote tracker site for another DB2 subsystem.
When YES, this is a tracker site.
A DB2 tracker site is a separate DB2 subsystem or data sharing group that exists solely for the purpose of keeping shadow copies of your primary site's data. No independent work can be run on the tracker site.
Install parameter TRACKER TYPE on panel DSNTIPO, or ZPARM TRKRSITE in DSN6SPRM.
Field Name: QWP4TRKR
- ENFORCE DPROP
Shows whether DataPropagator NonRelational (DPROP) is used to propagate SQL changes made to tables defined with DATA CAPTURE CHANGES.
- 1
- No changes are propagated.
- 2
- DPROP propagates SQL changes, and those changes made to tables defined with DATA CAPTURE CHANGES are only allowed when monitor trace class 6 is active, DPROP is installed, and the DB2 application is running in an IMS environment. If any of these conditions are not met, no changes to the DB2 table are permitted.
- 3
- Data propagation occurs when monitor trace class 6 is active, DPROP is installed, and the DB2 application is running in an IMS environment. In this instance, an application that is not running in an IMS environment can update DB2 tables defined with DATA CAPTURE CHANGES. However, these changes are not propagated to IMS.
- ANY
- Allows subsystems to propagate some data with DPROP and other data with a different propagation program.
Tables that should only be updated by DB2 applications running in an IMS environment can be protected using the following methods:- Use the ENABLE parameter on BIND to specify a specific attachment facility through which updates to data propagation tables can be made.
- Define a validation procedure for data propagation tables to define which plans can update those tables.
- Allow update authority for data propagation tables to a group of authorization IDs that can only run in IMS.
Install parameter DPROP SUPPORT on panel DSNTIPO, or ZPARM EDPROP and CHGDC in DSN6SPRM.
Field Name: QWP4ENF
- DDCS ESCAPE CHAR
The escape character used in the application registration table (ART) or object registration table (ORT).
Sets of names in the ART and ORT can be represented by patterns that use the underscore (_) and percent sign (%) characters in the same way as in an SQL LIKE predicate.
Install parameter ART/ORT ESCAPE CHARACTER on panel DSNTIPZ, or ZPARM RGFESCP in DSN6SPRM.
Field Name: QWP4ESC
- WAIT RETAIN LOCKS
Indicates whether a request is suspended until an incompatible retained lock becomes available.
This value is only significant in a data sharing environment. It indicates how long a transaction should wait for a lock on a resource if another DB2 in the data sharing group has failed and is holding an incompatible lock on that resource. Locks held by failed DB2 members are called retained locks.
This value is a multiplier that is applied to the connection's normal timeout value. For example, if the retained lock multiplier is 2, then the timeout period for a call attachment connection that is waiting for a retained lock is twice the normal CAF timeout period. The default is 0, meaning applications do not wait for incompatible retained locks, the lock request is immediately rejected and the application receives a "resource unavailable" SQLCODE.
Install parameter RETAINED LOCK TIMEOUT on panel DSNTIPI, or ZPARM RETLWAIT in DSN6SPRM.
Field Name: QWP4WAIT
- IMS/BMP TIMEOUT
The number of RESOURCE TIMEOUT units that an IMS BMP connection waits for a lock to be released.
The default value is 4, meaning that an IMS BMP connection can wait 4 times the resource timeout value for a resource.
Install parameter IMS BMP TIMEOUT on panel DSNTIPI, or ZPARM BMPTOUT in DSN6SPRM.
Field Name: QWP4WBMP
- BIND NEW PACKAGE
Shows whether BIND or BINDADD authority is required to BIND a new version of an existing package.
When BINDADD (default), only users with BINDADD system privilege can create a new package.
BIND users with BIND privilege for a package or collection can create a new version of an existing package when they bind it. This also allows users with PACKADM authority to add a new package or a new version of a package to a collection.
Install parameter BIND NEW PACKAGE on panel DSNTIPP, or ZPARM BINDNV in DSN6SPRM.
Field Name: QWP4BNVA
- AUTO BIND
- Indicates whether autobind is enabled. Values are:
- YES
- Allows automatic rebind operations to be performed when a
plan/package:
- Was marked "invalid".
- Was bound on DB2 Vn, but is now running on DB2 Vn-1
- After use on DB2 Vn-1 (as previously described), is later used again on DB2 Vn
- NO
- Prevent DB2 from performing any automatic rebind operations under any circumstances.
- COEXIST
- Allows automatic rebind operation to be performed in
a DB2 Data Sharing
coexistence environment when the plan/package:
- Is marked "invalid" or
- Was last bound in DB2 Vn and is running on DB2 Vn-1
Install parameter AUTO BIND on panel DSNTIPO, or ZPARM ABIND in DSN6SPRM.
Field Name: QWP4ABN
- IMS/DLI TIMEOUT
The number of RESOURCE TIMEOUT units that a DL/I batch connection waits for a lock to be released.
The default value is 6, meaning that an IMS BMP connection can wait 4 times the resource timeout value for a resource.
Install parameter DL/I BATCH TIMEOUT on panel DSNTIPI, or ZPARM DLITOUT in DSN6SPRM.
Field Name: QWP4WDLI
- ENABLE DB2 AUTH
Shows whether DB2 performs authorization checking.
When all authorization checking by DB2 is disabled, the GRANT statement is also disabled (granting every privilege to PUBLIC); this is not recommended.
Install parameter USE PROTECTION on panel DSNTIPP, or ZPARM AUTH in DSN6SPRM.
Field Name: QWP4AUTH
- MAX APPL LOCKS
The maximum number of page or row locks that a single application can hold concurrently on all table spaces.
This includes locks on data pages, index pages, and
rows that the program acquires when it accesses table spaces.
The limit applies to all table spaces defined with the LOCKSIZE PAGE, LOCKSIZE ROW, or LOCKSIZE ANY options. 0 means that there is no limit to the number of page and row locks a program can acquire.
DB2 assumes that 250 bytes of storage are required for each lock. If NO is specified for CROSS MEMORY, the value of this field has to take into account the available lock space. If referential constraints between tables is defined, the value of this field might need to be increased.
Install parameter LOCKS PER USER on panel DSNTIPJ, or ZPARM NUMLKUS in DSN6SPRM.
Field Name: QWP4LKUS
- CACHE DYNAMIC SQL
Indicates whether prepared dynamic SQL statements are saved for later use by eligible application processes in the EDM pool.
Install parameter CACHE DYNAMIC SQL on panel DSNTIP8, or ZPARM CACHEDYN in DSN6SPRM.
Field Name: QWP4CDYN
- AUTH CACHE SIZE
The size of the authorization cache to be used if no CACHESIZE is specified on the BIND PLAN subcommand.
The size of the cache is 32 bytes of overhead + (8 bytes of storage X number of concurrent users).
0 means authorization caching is not used.
Install parameter PLAN AUTH CACHE on panel DSNTIPP, or ZPARM AUTHCACH in DSN6SPRM.
Field Name: QWP4AUCA
- REP READ U LOCK
Indicates whether the U (UPDATE) lock is used when using repeatable read (RR) or read stability (RS) isolation to access a table.
When YES, the U lock is used for an updated cursor with repeatable read or read stability.
When NO, the S lock is used for an updated cursor with repeatable read or read stability. If the cursor in the running applications includes the clause FOR UPDATE OF, but updates are infrequent, S locks generally provide better performance.
Install parameter U LOCK FOR RR/RS on panel DSNTIPI, or ZPARM RRULOCK in DSN6SPRM.
Field Name: QWP4RRU
- MAX KEPT DYN STMT
Shows the total number of prepared dynamic SQL statements that are saved past a commit point.
0 means that prepared dynamic SQL statements are not saved past commit points.
Install parameter MAX KEPT DYN STMTS on panel DSNTIPE, or ZPARM MAXKEEPD in DSN6SPRM.
Field Name: QWP4MXKD
- ACCEL MODELING
The ACCELMODEL subsystem parameter determines whether to enable modeling of query workload for evaluating potential savings for both the accumulated elapsed time and CPU time if the plan is executed on an accelerator.
Only queries that are deemed eligible for execution on an accelerator by DB2® will be included in accelerator-related fields of Accounting trace IFCID 3:
- No
- Specifies that no modeling is to be performed. This is the default setting.
- Yes
- Specifies that modeling is to be performed. Consider acceleration eligibility for an SQL statement and update the new Accounting fields accordingly.
To enable modeling, the IBM DB2 Analytics Accelerator for z/OS® special register CURRENT QUERY ACCELERATION and ZPARM QUERY_ACCELERATION (set by the CURRENT QUERY ACCEL) must be set to NONE for accelerator modeling. All other values for the special register and ZPARM will take the existing logic of IBM DB2 Analytics Accelerator for z/OS. This means that existing queries that already execute on the accelerator with CURRENT QUERY ACCELERATION = ENABLE, ENABLE WITH FAILBACK, ELIGIBLE, or ALL will not be part of the accelerator-related Accounting fields.
Field Name: QWP4ACMO
- MAX TSPACE LOCK
The default (SYSTEM) for the LOCKMAX clause of the SQL statements CREATE TABLESPACE and ALTER TABLESPACE.
Install parameter LOCKS PER TABLE(SPACE) on panel DSNTIPJ, or ZPARM NUMLKTS in DSN6SPRM.
Field Name: QWP4LKTS
- CURRENT DEGREE
Shows the default for the CURRENT DEGREE special register when no degree is explicitly set with SET CURRENT DEGREE.
The default disables query parallelism.
Install parameter CURRENT DEGREE on panel DSNTIP8, or ZPARM CDSSRDEF in DSN6SPRM.
Field Name: QWP4CDEG
- OPT HINTS ALLOWED
Shows whether DB2 can use optimization hints from the PLAN_TABLE to influence the access paths used for certain queries.
Install parameter OPTIMIZATION HINTS on panel DSNTIP8, or ZPARM OPTHINTS in DSN6SPRM.
Field Name: QWP4HINT
- SORT POOL SIZE
Indicates the amount of storage needed for the sort pool.
This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.
Install parameter SORT POOL SIZE on panel DSNTIPC, or ZPARM SRTPOOL in DSN6SPRM.
Field Name: QWP4SPOL
- STATIC DESCRIBE
Shows whether DB2 builds a DESCRIBE SQLDA when binding static SQL statements.
A DESCRIBE cannot be issued against a static SQL statement except:- In a distributed environment, where DB2 for z/OS is the server and the requester supports extended dynamic SQL. In this instance, a DESCRIBE on an SQL statement in the extended dynamic package appears to DB2 as a DESCRIBE on a static SQL statement in the DB2 package.
- When an application uses a stored procedure result set, the application must allocate a cursor for that result set. The application can do this using a DESCRIBE CURSOR statement. The SQL statement actually described is the one with the cursor declared in the stored procedure. If that statement is static, a static SQL statement must be described.
When NO (default), DB2 does not generate a DESCRIBE SQLDA at BIND time for static SQL statements. If a DESCRIBE request is received at execution time, DB2 generates an error. However, if the describe request comes from a DESCRIBE CURSOR statement, DB2 satisfies the request but is only able to provide data type and length information. Column names are not provided.
When YES, DB2 generates a DESCRIBE SQLDA at BIND time so that DESCRIBE requests for static SQL can be satisfied during execution.
Note: You must rebind packages after this value has been set to YES.This option increases the size of some packages because the DESCRIBE SQLDA is now stored with each statically-bound SQL SELECT statement.
Install parameter DESCRIBE FOR STATIC on panel DSNTIP4, or ZPARM DESCSTAT in DSN6SPRM.
Field Name: QWP4DSST
- RIDPOOL SIZE (KB)
The amount of storage needed for the RID pool.
This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.
When 0, DB2 does not use access paths or join methods that depend on RID pool storage.
Install parameter RID POOL SIZE on panel DSNTIPC, or ZPARM MAXRBLK in DSN6SPRM.
Field Name: QWP4RMAX
- PACK AUTH CACHE
The amount of storage allocated for caching authorization information for all packages on this DB2 member.
32 KB hold about 375 collection-ID.package-IDs. The cache is stored in the DSN1DBM1 address space.
Install parameter PACKAGE AUTH CACHE on panel DSNTIPP, or ZPARM CACHEPAC in DSN6SPRM.
Field Name: QWP4PAC
- CONTR THREAD STOR
- In DB2 12 this field is a serviceability field.Indicates whether DB2 returns unused thread storage at commit. Possible values are:
- YES
- DB2 checks threads at commit points and periodically returns unused storage to the system.
- NO
- DB2 does not check threads at commit points and returns acquired storage on deallocation.
Install parameter CONTRACT THREAD STG on panel DSNTIPE, or ZPARM CONTSTOR in DSN6SPRM.
Field Name: QWP4CONT
- MAX DEG OF PARALL
Indicates the upper limit on the degree of parallelism for a parallel group.
This field has a value of 0. This means PARAMDEG is not set and DB2 can set a default maximum degree of parallelism based on the system configuration.
Install parameter MAX DEGREE on panel DSNTIP8, or ZPARM PARAMDEG in DSN6SPRM.
Field Name: QWP4MDEG
- RTN AUTH W/O CAT
The amount of storage allocated for caching authorization information for all routines on this DB2 member.
Routines include stored procedures and user-defined functions.
32 KB hold about 380 schema.routine.type entries.
Install parameter ROUTINE AUTH CACHE on panel DSNTIPP, or ZPARM CACHERAC in DSN6SPRM.
Field Name: QWP4RAC
- USE X LOCK
The locking method used when performing a searched UPDATE or DELETE.
When NO, DB2 uses an S or U lock when scanning for qualifying rows. For any qualifying rows or pages the lock is upgraded to an X lock before performing the update or delete. For nonqualifying rows or pages the lock is released if using ISOLATION(CS). For ISOLATION(RS), or ISOLATION(RR), an S lock is retained on the rows or pages until the next commit point. This option is used to achieve higher rates of concurrency.
When YES, DB2 gets an X lock on qualifying rows or pages. For ISOLATION(CS), the lock is released if the rows or pages are not updated or deleted. For ISOLATION(RS) or ISOLATION(RR), an X lock is retained until the next commit point. This is beneficial in a data sharing environment when most or all searched updates and deletes use an index. The downside is that if searched updates or deletes result in a tablespace scan, the likelihood of timeouts and deadlocks greatly increases.
Install parameter X LOCK FOR SEARCHED U/D on panel DSNTIPI, or ZPARM XLKUPDLT in DSN6SPRM.
Field Name: QWP4XLUD
- STAR JOIN ENABL
- Star join enable indicator. Possible values are:
- -1 (DISABLE)
- Star join is disabled. This is the default.
- 0 (ENABLE)
- Star join is enabled when the join meets the conditions described in the DB2 administration information for performance.
- 1
- Star join is enabled without comparing the ratio of the fact-table cardinality to the cardinality of the largest dimension table. The table with the largest cardinality is the fact table.
- n
- This is the star join fact table and the largest dimension table ratio. The lowest ratio of the cardinality of the fact table compared to the cardinality of the largest dimension table for which star join is used. 2 < N <= 32768.
Install parameter STAR JOIN QUERIES on panel DSNTIP8, or ZPARM STARJOIN in DSN6SPRM.
Background and Tuning Information
This parameter allows you to set the star join ratio to increase or decrease the dimension table and fact table ratio rule according to application needs.
This parameter also allows you to disable star join if needed for performance reasons. The default is to allow star join if star join detection is successful.
Star join technique is only used when these conditions exist:- At least two dimensions exist.
- The join predicates are between the fact table and the dimension tables only. (No join predicates lie between the dimension tables.)
- The join predicates are equijoin predicates.
- No correlated subqueries cross dimensions.
- No cycles within the dimensions exist. This means that no predicate can reference more than one candidate dimension table with respect to the same column of the fact table.
- No outer join exists.
- The data type and length of the join predicates are the same.
- The fact table is larger than the dimension table.
Field Name: QWP4SJRT
- NPAGES THRESHOLD
- This parameter allows you to specify the optimizer threshold for qualifying a table as small.
- -1
- Every table qualifies as small.
- 0
- No table qualifies as small (this is the default).
- 1
- Only tables with zero pages qualify as small.
- 2
- Tables with less than two pages qualify as small.
- 10
- Tables with less than ten pages qualify as small.
- 502
- Tables with less than 502 pages, and tables that have not had statistics collected qualify as small. For example, when NPAGES = -1.
DB2 parameter NPGTHRSH in DSN6SPRM.
Background and Tuning Information
Tables can be populated using insert just prior to their use by queries and then cleared immediately on completion of the queries. These tables are permanent even though the data they contain is transient.
This can cause problems when RUNSTATS is run overnight, or at other times when these tables are empty. This gives the optimizer the false indication that these tables contain no data when in fact, the tables will contain data when the query executes. This causes the optimizer to pick an inefficient access path. Usually the optimizer chooses to do a table scan, which would be the most efficient access path if the table were truly empty. Because the table is not empty when the query executes, it would be more efficient to use matching index access.
With this parameter, you can force the optimizer to treat tables containing no data as small tables. For these tables, the optimizer will:- Select a matching index access rather than a table space scan and non-matching index access.
- Select the index with the most matching columns when more than one index qualifies for matching index access.
- Select indexes with the same number of matching columns on cost.
Field Name: QWP4NPAG
- DBADM CREATE VIEW
Shows whether a DB2 administrator can create a view or alias for another user. Possible values are YES or NO. The default is NO.
Install parameter DBADM CREATE AUTH on panel DSNTIPP. ZPARM DBACRVW in macro DSN6SPRM.
Field Name: QWP4CRVW
- MAX # LE TOKENS
The maximum number of LE tokens active at any time. When zero, no tokens are available.
A token is used each time one of the following is used: trigonometry functions, degrees, radians, rand, exp, power, log functions, upper, lower, translate.
Install parameter MAXIMUM LE TOKENS on panel DSNTIP7, or ZPARM LEMAX in DSN6SPRM.
Field Name: QWP4LEM
- MAX EXT SERV TASK
Maximum number of extended service tasks.
Field Name: QWP4EST
- PROJ Z INS THRESH
Project z insertion threshold.
Field Name: QWP4ZTN
- MAX NOT FOUND-HSH
The maximum number of NOT FOUND hash records.
Field Name: QWP4KNFC
- FIELD PROCS T BLK
The number of field procedures for the DESCRIBE TABLE block.
ZPARM SPRMFDP.
Field Name: QWP4FDP
- MANAGE THREAD STO
- In DB2 12 this field is a serviceability field.
Shows whether DB2 uses storage management to optimize the amount of working storage consumed by individual threads.
Install parameter MANAGE THREAD STORAGE on panel DSNTIPE, or ZPARM MINSTOR in DSN6SPRM.
For best performance, this parameter should be NO, meaning DB2 does not manage thread storage.
When YES, DB2 uses best fit algorithm to manage and assign thread storage. This can help on systems that have many long-running threads and that are constrained on DBM1 address space.
Field Name: QWP4MSTG
- EVAL UNCOMMITTED
Shows whether stage 1 predicate evaluation during table access can proceed upon uncommitted data or not.
This applies to isolation levels of Read Stability and Cursor Stability only.
When NO (default), predicate evaluation occurs only on committed data (or on the application's own uncommitted changes). NO ensures that all qualifying data is always included in the answer set.
When YES, predicate evaluation can occur upon uncommitted data. Only committed data is returned to the query. However, a decision can be made to omit a row from the answer set based on uncommitted data. Later, undo processing (statement rollback or statement failure) could cause the data to revert to a state that satisfies the predicate.
When YES, DB2 can request fewer locks than in previous versions when processing isolation level Read Stability and Cursor Stability queries. The number of locks avoided is related to the access path of the query, the number of rows evaluated when processing the stage 1 predicate of the query, and the number of those rows that are overflow rows. Specifically, for isolation level Read Stability and Cursor Stability queries, locks are avoided for rows that do not satisfy the stage 1 predicate, provided they are not overflow rows. Table access includes table space scans and index-to-data access, including ridlist-to-data access. For isolation Cursor Stability ridlist production, all row/page locking is avoided.
Install parameter EVALUATE UNCOMMITTED on panel DSNTIP8, or ZPARM EVALUNC in DSN6SPRM.
Field Name: QWP4EVUN
- STATISTICS ROLLUP
Shows whether RUNSTATS utility aggregates the partition level statistics, even though some parts may not contain data.
This should be YES for DB2 systems that have large partitioned table spaces, index spaces, or both. This enables the aggregation of part level statistics and helps the optimizer to choose a better access path.
Install parameter STATISTICS ROLLUP on panel DSNTIPO, or ZPARM STATROLL in DSN6SPRM.
Field Name: QWP4STRL
- STATISTICS HIST
Shows which inserts and updates are recorded in catalog history tables.
The report can show the following values:- N / NONE
- Changes in the catalog are not recorded. This is the default.
- A / ALL
- All inserts and updates in the catalog are recorded.
- P / ACCESSPATH
- All inserts and updates to access path related catalog statistics are recorded.
- S / SPACE
- All inserts and updates to space related catalog statistics are recorded.
Install parameter STATISTICS HISTORY on panel DSNTIPO, or ZPARM STATHIST in DSN6SPRM.
Field Name: QWP4STHT
- SUPPRESS SOFT ERR
Shows whether the recording of errors, such as invalid decimal data and arithmetic exceptions, in the operating system data set SYS1.LOGREC is suppressed.
When YES, these exceptions are not recorded in the LOGREC data set.
Install parameter SUPPRESS SOFT ERRORS on panel DSNTIPM or ZPARM SUPERRS in DSN6SPRM.
Field Name: QWP4SAE
- REAL TIME STATS
The time interval that DB2 waits before it attempts to write out page set statistics to the real-time statistics tables. This value is between 1 and 65535 minutes.
Install parameter REAL TIME STATS on panel DSNTIPO, or ZPARM STATSINT in DSN6SPRM.
Field Name: QWP4INTE
- EDM STATMNT CACHE
The size of the statement cache that can be used by the Environmental Descriptor Manager (EDM). This value is used at DB2 startup time as the minimum value. You can increase and subsequently decrease this value with the SET SYSPARM command. This value cannot be decreased below the value that is specified at DB2 startup. The CLIST calculates a statement cache size. This storage pool is located above the 2 GB bar.
The value used at DB2 startup time is either calculated by the CLIST based on input from other installation information or an override value.
For record trace, this value is shown in bytes. For other reports, the value is shown in kilobytes.
Install parameter EDM STATEMENT CACHE on panel DSNTIPC, or ZPARM EDMSTMTC in DSN6SPRM.
Field Name: QWP4ESTC
- STAR JOIN THRESH
The minimum number of tables in the star schema query block, including the fact table, dimensions tables, and snowflake tables. This value is considered only if the subsystem parameter STARJOIN qualifies the query for star join.
Possible values are:- 0
- Star join is disabled. This is the default.
- 1, 2, or 3
- Star join is always considered.
- 4 through 255
- Star join is considered if the query block has at least the specified number of tables.
- 256 and greater
- Star join is never considered.
DB2 parameter SJTABLES in DSN6SPRM.
Background and Tuning Information
Although star join can reduce bind time significantly it does not provide optimal performance in all cases. Performance of star join depends on a number of factors such as the available indexes on the fact table, the cluster ratio of the indexes, and the selectivity of rows through local and join predicates. Follow these general guidelines for setting the value of SJTABLES:- If you have star schema queries with less than 10 tables and you want to make the star join method applicable to all qualified queries, set the value of SJTABLES to a low number, such as 5.
- If you have some star schema queries that are not necessarily suitable for star join but want to use star join for relatively large queries, use the default. The star join method will be considered for all qualified queries that have 10 or more tables.
- If you have star schema queries but normally do not want to use star join, you could increase SJTABLES, say to 15. This will greatly cut the bind time for large queries and avoid a potential bind time SQL return code -101 for large qualified queries.
Field Name: QWP4SJTB
- ZOSMETRICS
YES indicates that gathering of z/OS metrics using the RMF interface is enabled. ZPARM ZOSMETRICS in DSN6SPRM.
Field Name: QWP4METE
- EDM DBD CACHE
The minimum size of the DBD cache that can be used by the Environmental Descriptor Manager (EDM). This value is used at DB2 startup time as the minimum value. You can increase and subsequently decrease the value with the SET SYSPARM command. This value cannot be decreased below the value that is specified at DB2 startup. This storage pool is located above the 2 GB bar. The CLIST calculates the DBD cache size.
The value used at DB2 startup time is either calculated by the CLIST based on input from other installation information or an override value.
Install parameter EDM DBD CACHE on panel DSNTIPC, or ZPARM EDMDBDC in DSN6SPRM.
Field Name: QWP4EDBC
- LONG RUNNING READ
Shows the number of minutes that a read claim can be held by an agent before DB2 reports it as a long-running reader. Valid values are 0 (default) through 1439.
Install parameter LONG-RUNNING READER on installation panel DSNTIPE, or ZPARM LRDRTHLD in DSN6SYSP.
Field Name: QWP4LRTH
- MAX OPEN CURSORS
Shows the maximum number of cursors, including allocated cursors, that are open at a given DB2 site per thread. RDS keeps a total of currently open cursors. If an application attempts to open a thread after the maximum is reached, the statement will fail.
In a data sharing group, this parameter is shown at member scope.
Install parameter MAX OPEN CURSORS on panel DSNTIPX, or ZPARM MAX_NUM_CUR in DSN6SPRM.
Field Name: QWP4MXNC
- EDM SKEL POOLSIZE
The minimum size of the EDM pool for skeleton package and skeleton cursor tables. For record trace, this value is shown in bytes. For other reports, the value is shown in kilobytes.
Install parameter EDM SKELETON POOL SIZE on panel DSNTIPC or ZPARM EDM_SKELETON_POOL in DSN6SPRM.
Field Name: QWP4SKLC
- CUR MAINT TYPE
- Shows the default special register for the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION statement when no value is explicitly set. Possible values are:
- ALL
- NONE
- SYSTEM (default)
- USER
The default allows query rewrite using system-maintained materialized query tables (SYSTEM) when CURRENT REFRESH AGE is set to ANY. When USER, query rewrite is done using user-maintained materialized query tables when CURRENT REFRESH AGE is set to ANY. ALL means that query rewrite uses both system-maintained and user- maintained materialized query tables.
Install parameter CURRENT MAINT TYPES on panel DSNTIP8, or ZPARM MAINTYPE in DSN6SPRM.
Field Name: QWP4MNTY
- PAD IDX BY DEFLT
- Shows whether new indexes are be padded by default.
- YES indicates that a new index is padded unless the NOT PADDED option is specified on the CREATE INDEX statement.
- The default value, NO, indicates that a new index is not padded unless the PADDED option is specified on the CREATE INDEX statement.
Install parameter PAD INDEXES BY DEFAULT on installation panel DSNTIPE, or ZPARM PADIX in DSN6SPRM.
Field Name: QWP4PDIX
- MIN DIVIDE SCALE
The minimum scale for the result of a decimal division. The values for this parameter are none (the default), 3, or 6. If 3 or 6 is specified, this parameter overrides the DECDIV3 parameter.
Field Name: QWP4MDSC
- FREE CACHED STMTS
- Indicates whether DB2 can free statements from the local dynamic statement cache to relieve storage constraints below the 2 GB bar. This parameter applies only for packages or plans that are bound with KEEPDYNAMIC(YES). Possible values are:
- 0
- DB2 cannot free statements from the local cache
- 1
- DB2 can free statements from the local cache
DB2 parameter CACHEDYN_FREELOCAL in DSN6SPRM.
Field Name: QWP4FRLC
- TEMP UNIT NAME
Shows the device type or unit name for allocating temporary data sets. It is the direct access or disk unit name used for the precompiler, compiler, assembler, sort, linkage editor, and utility work-files in the tailored jobs and CLISTs.
It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION options for DFSORT.
The default is SYSDA.
Install parameter TEMPORARY UNIT NAME on DSNTIPA2, or ZPARM VOLTDEVT in DSN6SPRM.
Field Name: QWP4VDTY
- CUR REFRESH AGE
Shows the default for the CURRENT REFRESH AGE special register deferred materialized query tables.
Install parameter CURRENT REFRESH AGE on panel DSNTIP8, or ZPARM REFSHAGE in DSN6SPRM.
Field Name: QWP4RFSH
- MAX DATA CACHING
The maximum amount of virtual memory in megabytes (MB) that is allocated for data caching.
Install parameter MAX DATA CACHING on panel DSNTIP8, or ZPARM MXDTCACH in DSN6SPRM.
Field Name: QWP4MXDC
- ONL ZPARM TYPE
The type of DB2 system parameter changed by the last SET SYSPARM statement.
Field Name: QWP4OZTP
- RESTORE/RECOVER
If YES, the system-level backup that is the recovery base, is from a dump on tape. Otherwise NO is shown.
Install parameter RESTORE/RECOVER on installation panel DSNTIP6, or ZPARM RESTORE_RECOVER_FROMDUMP in DSN6SPRM.
Field Name: QWP4RRFD
- MAX STORED PROCS
Shows the maximum number of stored procedures per thread. If an application attempts to call a stored procedure after this is reached, the statement will fail. In a data sharing group, this parameter is shown as member scope.
Install parameter MAX STORED PROCS on panel DSNTIPX, or ZPARM MAX_ST_PROC in DSN6SPRM.
Field Name: QWP4MXSP
- ONL ZPARM USER ID
The user ID that made the last online change to DB2 system settings.
Field Name: QWP4OZUS
- INDEX I/O PARALL
- In DB2 12 this field is a serviceability field.
The enablement of the index I/O parallelism ZPARM.
Field Name: QWP4IIOP
- MAX TEMP STORAGE
The maximum amount of temporary storage in megabytes (MB) for each agent.
Install parameter MAX TEMP STORAGE on panel DSNTIP6 or ZPARM MAXTEMPS in DSNTIP9.
Field Name: QWP4WFAL
- ONL ZPARM CORID
The correlation ID of the online application that made the last change to DB2 system settings.
Field Name: QWP4OZCI
- REVOKE DEP PRIVIL
- Include dependent privileges on REVOKE. Possible values are:
- Y
- If INCLUDING DEPENDENT PRIVILEGES is enforced.
- N
- If NOT INCLUDING DEPENDENT PRIVILEGES is enforced.
- S
- If specified in a REVOKE statement.
Field Name: QWP4RVDPR
- MAX CONC AUTOBIND
The maximum number of package requests that can be processed simultaneously.
DB2 parameter MAX_CONCURRENT_PKG_OPS in DSN6SPRM.
Field Name: QWP4MXAB
- ONL ZPARM TIME
Time of the last online change made to DB2 system settings.
Field Name: QWP4OZTM
- PLANMGMT
Shows if and how access path information is stored in the repository. Possible values are:
- O
- On
- F
- Off
- B
- Basic
- E
- Extended
Field Name: QWP4PMGT
- ADM SCHED JCLPROC
The name of the JCL procedure for starting the DB2 administrative scheduler task address space.
DB2 parameter ADMTPROC in DSN6SPRM.
Field Name: QWP4ADMT
- SYS-LEVEL BACKUP
Shows if RECOVER uses system level backups as the recovery base.
Install parameter SYSTEM-LEVEL BACKUPS on installation panel DSNTIP6, or ZPARM SYSTEM_LEVEL_BACKUPS in DSN6SPRM.
Field Name: QWP4SLBU
- PLANMGMTSCOPE
Controls which queries are populated in the access path repository (ZPARM parameter PLANMGMTSCOPE). Possible values are:
- A
- ALL: Includes static and dynamic SQL queries.
- S
- STATIC: Includes static SQL queries only. This is the default.
- D
- DYNAMIC: Includes dynamic SQL queries only.
Field Name: QWP4PMSC
- DUMP CLASS NAME
The name of the DFSMSHSM dump class used by the restore system utility to restore from a system-level backup that has been dumped to tape.
Install parameter DUMP CLASS NAME on installation panel DSNTIP6, or ZPARM UTILS_DUMP_CLASS_NAME in DSN6SPRM.
Field Name: QWP4RSDC
- 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
- SEPARATE SECURITY
Separate security tasks. Possible values are:
- Y
- SYSADM/SYSCTRL cannot GRANT/REVOKE
- N
- SYSADM/SYSCTRL can GRANT/REVOKE
Field Name: QWP4SEPSD
- SECADM1 ID
Security administrator 1.
Field Name: QWP4SECA1
- SECADM1 TYPE
- Security administrator 1 type. Possible values are:
- ' '
- Blank indicates that the authorization ID (AUTH ID) is used.
- 'L'
- Indicates that ROLE is used.
This field corresponds to field SEC ADMIN 1 TYPE on installation panel DSNTIPP1, or ZPARM SECADM1_TYPE in DSN6SPRM.
Field Name: QWP4SECA1_TYPE
- MAX TEMP RID
The maximum number of RID blocks of temporary storage in the Workfile database that a single RID list can use at any point in time. This field corresponds to field MAX TEMP RID on installation panel DSNTIP9. The ZPARM name is MAXTEMPS_RID.
It can have the following values:- -1 if MAXTEMPS_RID=NONE
- 0 if MAXTEMPS_RID=NOLIMIT
- 1 to 329166 otherwise
Field Name: QWP4WFRD
- SECADM2 ID
Security administrator 2.
Field Name: QWP4SECA2
- SECADM2 TYPE
- Security administrator 2 type. Possible values are:
- 'blank'
- Indicates that the authorization ID (AUTH ID) is used.
- 'L'
- Indicates that ROLE is used.
This field corresponds to field SEC ADMIN 2 TYPE on installation panel DSNTIPP1, or ZPARM SECADM2_TYPE in DSN6SPRM.
Field Name: QWP4SECA2_TYPE
- SKIP UNCOMM INS
YES indicates that uncommitted inserts are treated as if they have not yet been executed. The ZPARM name is SKIPUNCI.
Field Name: QWP4SKUI
- GET ACCEL ARCHIVE
Determines the default value that is to be used for the CURRENT GET_ACCEL_ARCHIVE special register:
- NO
- Indicates that if a table is archived in an accelerator server, and a query references that table, the query does not use the data that is archived.
- YES
- Indicates that if a table is archived in an accelerator server, and a query references that table, the query uses the data that is archived.
ZPARM name GET_ACCEL_ARCHIVE in macro DSN6SPRM.
Field Name: QWP4CGAA
- LMT CONV PART TAB
Shows whether to include all columns in the partitioning key during conversion from index-controlled partitioning to table-controlled partitioning:
- NO
- Includes all columns
- YES
- Includes trailing columns only if they affect partitioning
This field corresponds to field EXCLUDE PART KEY ELEMENTS on installation panel DSNTIP71. The ZPARM name is IX_TB_PART_CONV_EXCLUDE in DSN6SPRM.
Field Name: QWP4XPKE
- DDL TIMEOUT FACT
Shows the time out factor of the SQL data definition. The time out value is the product of this value and the IRLMRWT value.
ZPARM name DDLTOX in DSN6SPRM.
Field Name: QWP4DDLTO
- CUR QUERY ACCEL
Determines the default value that is to be used for the CURRENT QUERY ACCELERATION special register. Possible values are:
- NONE
- Indicates that no query acceleration is done. This is the default value.
- ENABLE
- Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
- ENABLE_WITH_FAILBACK
- Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If the accelerator returns an error during the PREPARE or first OPEN for the query, DB2 executes the query without the accelerator. If the accelerator returns an error during a FETCH or a subsequent OPEN, DB2 returns the error to the user, and does not execute the query.
- ELIGIBLE
- Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine whether to accelerate the queries. Queries that are not eligible for acceleration are executed by DB2. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
- ALL
- Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine whether to accelerate the queries. Queries that are not eligible for acceleration are not executed by DB2, and an SQL error is returned. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
ZPARM name QUERY_ACCELERATION in DSN6SPRM.
Field Name: QWP4CQAC
- REORG SORT NPSI
Specifies the default method of building a non-partitioned secondary index during the REORG tablespace part. This setting is used when the SORTNPSI keyword is not specified in a utility control statement.
Possible values are:
- Auto
- Disable
- Enable
This field corresponds to field REORG PART SORT NPSI in installation panel DSNTIP61. The ZPARM name is REORG_PART_SORT_NPSI in DSN6SPRM.
Field Name: QWP4RPSN
- MAX UTIL PARALL
The maximum degree of utility parallelism.
Field Name: QWP4UMD
- ACCEL STARTUP OPT
Specifies whether to enable accelerator servers. Possible values are:
- AUTO
- Enable and start accelerator servers.
- COMMAND
- Enable but do not start accelerator servers.
- NO
- Do not enable accelerator servers.
This field corresponds to field ACCEL STARTUP on installation panel DSNTIP81. ZPARM name is ACCEL in DSN6SPRM.
Field Name: QWP4ACCS
- REORG IGN FREESPC
- YES indicates that REORG tablespace does not use the PCTFREE and FREEPAGE values when it reloads data rows into a partition-by-growth (PBG) table space if:
- A subset of the partitions is reorganized.
- The associated table contains LOB columns that cause a REORG AUX NO REQUEST to fail.
This field corresponds to field REORG IGNORE FREESPACE in installation panel DSNTIP61. ZPARM name is REORG_IGNORE_FREESPACE in DSN6SPRM.
Field Name: QWP4RIFS
- MULT INDEX ACCESS
Specifies whether to enable or disable multiple index access for queries that have subquery predicates:
- NO
- Disables multiple index access for queries.
- YES
- Enables multiple index access for queries.
The ZPARM name is SUBQ_MIDX IN DSN6SPRM.
Field Name: QWP4SQMX
- QUERY ACCEL OPT
Specifies additional types of SQL queries that are eligible for acceleration.
- NONE
- Indicates that no additional types of SQL queries are eligible. Therefore, the types of queries that are described in the other available values for this parameter are not eligible for acceleration. This is the default value.
- 1
- Indicates that queries that include data that is encoded with the EBCDIC mixed or graphic encoding schemes are eligible for acceleration.
- 2
- Indicates that an INSERT with SELECT statement is eligible for acceleration. However, only the SELECT operation of the query is processed by the accelerator server.
- 3
- Indicates that queries that contain built-in functions for which DB2 processes each byte of the input string, rather than each character of the input string, can run on an accelerator server.
- 4
- The queries that reference an expression with a DATE data type that uses a LOCAL format are not blocked from executing on IBM DB2 Analytics Accelerator for z/OS. IBM DB2 Analytics Accelerator for z/OS will use the dd/mm/yyyy format to interpret the input and output date value. Specify option 4 only when you also specify LOCAL as the setting for the DSNHDECP.DATE parameter and your LOCAL date exit defines the specific dd/mm/yyyy date format. Otherwise, queries may return unpredictable results.
- 5
- Allow OFFLOAD of SYSTEM_TIME temporal queries.
- 6
- Allow OFFLOAD of queries that reference
timestamp columns with a
precision of up to 12.
- 7
- OFFLOAD uses YYYYMMDD date format.
ZPARM name QUERY_ACCEL_OPTIONS in macro DSN6SPRM.
Field Name: QWP4QACO
- REORG TABSPC LIST
Specifies the default value for the REORG TABLESPACE PARALLEL option.
- Parallel
- Serial
The ZPARM name is REORG_LIST_PROCESSING in DSN6SPRM.
Field Name: QWP4RLPR
- OPT 1 ROW-NO SORT
- Specifies whether DB2 explicitly blocks sort
operations when the OPTIMIZE FOR 1 ROW
clause is specified on a query:
- NO = DISABLE
- Means that when OPTIMIZE FOR 1 ROW is specified, DB2 avoids access paths that involve sorts. If an access path that avoids a sort exists, it is possible, although unlikely, that an access path that involves a sort is chosen instead. This behavior is used in DB2 9 and earlier releases.
- YES = ENABLE
- Means that when OPTIMIZE FOR 1 ROW is specified, DB2 chooses access paths that avoid sorts whenever such a path is available.
ZPARM name is OPT1ROWBLOCKSORT in DSN6SPRM.
Field Name: QWP4O1RBS
- AUTH EXIT CHECK
Specifies whether the DB2 authorization ID or the RACF primary authorization ID is to be used for authorization checks, when the access control authorization exit is active:
- Primary
- DB2 provides:
- The ACEE of the package owner to perform statement authorization checks during AUTOMATIC REBIND, BIND, and REBIND processing
- The ACEE of the package owner, routine definer, or routine invoker, as determined by the dynamic rules behavior for dynamic SQL authorization checking, when a DYNAMICRULES BIND option value other than run is in effect.
- DB2
- DB2 provides the ACEE of the primary authorization ID for performing all authorization checks. The primary authorization ID must have the privileges required to execute the SQL statements in the package. This field corresponds to field "RACF AUTH CHECK" on installation panel DSNTIPP. ZPARM name is RACF_AUTHCHECK in DSN6SPRM.
Field Name: QWP4RACK
- REORG MAPPING DB
The default database in which REORG TABLESPACE SHRLEVEL change implicitly creates the mapping table. This field corresponds to field RECORD MAPPING DB on installation panel DSNTIP61. The ZPARM name RECORD_MAPPING_TABLE in DSN6SPRM.
Field Name: QWP4RMDB
- UTIL OBJ CONVERS
This field can have the following values:
- NONE (QWP4UTOC1=0 and QWP4UTOC2=0)
- No conversion is performed. This option is the default setting of this parameter. NONE is allowed regardless of the OBJECT CREATE FORMAT setting.
- BASIC (QWP4UTOC1=1 and QWP4UTOC2=0)
- Existing table spaces and indexes that use extended 10-byte page format are converted to basic 6-byte page format. BASIC is allowed only if the OBJECT CREATE FORMAT field is also set to BASIC.
- EXTENDED (QWP4UTOC1=0 and QWP4UTOC2=1)
- Existing table spaces and indexes that use 6-byte page format are converted to extended 10-byte page format. EXTENDED is allowed only if the OBJECT CREATE FORMAT field is also set to EXTENDED.
- NO BASIC (QWP4UTOC1=1 and QWP4UTOC2=1)
- Prevents the conversion of table spaces and indexes in extended page format to basic page format and disallows a utility that accepts the RBALRSN_CONVERSION utility keyword from running on an object in basic page format unless it converts it to extended page format. This setting is permitted only when OBJECT_CREATE_FORMAT=EXTENDED is set.
The ZPARM name is UTILITY_OBJECT_CONVERSION in DSN6SPRM.
Field Name: RT0106OC
- AUTHEX CACHE REF
Specifies whether the package authorization cache, routine authorization cache, and dynamic statement cache entries are refreshed when an access control authorization exit is active, and the user profile is changed in RACF. Possible values are:
- All
- None
This field corresponds to field AUTH EXIT CACHE REFR in installation panel DSNTIPP. ZPARM name is AUTHEXIT_CACHEREFRESH in DSN6SPRM.
Field Name: QWP4AECR
- REORG DROP PARTS
If YES, REORG completes, REORG drops empty, and trailing partitions are set in a PARTITION-BY-GROWTH table space.
This field corresponds to field REORG DROP PBG PARTS on INSTALLATION panel DSNTIP61. The ZPARM name is REORG_DROP_PBG_PARTS in DSN6SPRM.
Field Name: QWP4RPBG
- OBJ CREATE FORMAT
Creates new table spaces and indexes in the following log record format:
- EXTENDED
- Creates new table spaces and indexes in extended log record format.
- BASIC
- Creates new table spaces and indexes in basic log record format.
Field Name: QWP4OBCF
- PKG RLEASE COMMIT
- YES indicates that the following operations on a package that are bound with RELEASE(DEALLOCATE) are permitted while the package is active and allocated by DB2:
- BIND and REBIND requests, including AUTOMATIC REBIND
- Data definition language changes to objects that are statically referenced by the package
The ZPARM name is PKGREL_COMMIT in DSN6SPRM.
Field Name: QWP4PKRC
- REORG KEEP DICT
- 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
- TEMPLATE TIME
- Specifies the default setting for the TIME option of the template utility control statement. Possible values are:
- UTC (utility control)
- Local
This field corresponds to field TEMPLATE TIME on installation panel DSNTIP6. The ZPARM name is TEMPLATE_TIME in DSN6SPRM.
Field Name: QWP4TPTM
- MAX IN-MEM SORT
The maximum amount of storage in kilobytes to allocate for sorting the results of each query that contains the order by clause, the group by clause, or both. This field corresponds to field MAX IN-MEMORY SORT SIZE in installation panel DSNTIPC. The ZPARM name is MAXSORT_IN_MEMORY in DSN6SPRM.
Field Name: QWP4MIMTS
- STATIST FEEDBACK
Specifies the scope of SQL statements for which DB2 is to recommend statistics. Possible values are:
- All
- Dynamic
- None
- Static
This value corresponds to field STATISTICS FEEDBACK on installation panel DSNTIPO. The ZPARM name is STATFDBK_SCOPE in DSN6SPRM.
Field Name: QWP4SFBS
- MAX PARA DEG DPSI
The maximum degree of parallelism for a parallel group in which a data-partitioned secondary index is used to control parallelism. This field corresponds to field MAX DEGREE FOR DPSI on installation panel DSNTIP81. The ZPARM name is PARAMDEG_DPSI in DSN6SPRM.
Field Name: QWP4DEGD
- APPL COMPAT
Specifies the DB2 level for downward compatibility with applications. The ZPARM name is APPLCOMPAT in DSN6SPRM.
Field Name: QWP4APCO_VAR
- PCTFREE UPDATE
Specifies the default percentage of each page that DB2 leaves as free space in a table space when a table in this table space is populated. This value applies only to table spaces whose definitions do not include PCTFREE and for UPDATE.
This value corresponds to field PERCENT FREE FOR UPDATE on installation panel DSNTIP71. The ZPARM name is PCTFREE_UPD in DSN6SPRM.
Field Name: QWP4PFUP
- WF DB AGNT THRESH
Specifies the percentage of space that is used in the Workfile Database by a single agent when DB2 issues a warning message.
This value corresponds to field AGENT LEVEL THRESHOLD on installation panel DSNTIP91. The ZPARM name is WFSTGUSE_AGENT_THRESHOLD in DSN6SPRM.
Field Name: QWP4WFSAT
- LIKE BLANK INSIGN
YES indicates that blanks are not significant when DB2 applies the LIKE predicate to a string. Blanks are significant in DB2 10.
This setting corresponds to field LIKE BLANK INSIGNIFICANT on installation panel DSNTIP41. The ZPARM name is LIKE_BLANK_INSIGNIFICANT in DSN6SPRM.
Field Name: QWP4LBIN
- IDX CLEANUP THRDS
The maximum number of threads that can be created to clean up pseudo-deleted index entries on a data sharing member of a subsystem. This field corresponds to field INDEX CLEANUP THREADS on installation panel DSNTIPE1. The ZPARM name is INDEX_CLEANUP_THREADS in DSN6SPRM.
Field Name: QWP4IXCU
- WF DB SYS THRESH
Specifies the percentage of space that is used in the Workfile Database by all agents in a DB2 subsystem or data sharing member when DB2 issues a warning message.
This value corresponds to field SYSTEM LEVEL THRESHOLD on installation panel DSNTIP91. The ZPARM name is WFSTGUSE_SYSTEM_THRESHOLD in DSN6SPRM.
Field Name: QWP4WFSST
- D.STMT CACHE STOR
Specifies the number of gigabytes of storage that DB2 allocates for hashing entries in the dynamic statement cache. This parameter can avoid storage shortages for long-running threads. The storage is allocated above the bar.
The ZPARM name is CACHE_DEP_TRACK_STOR_LIM in DSN6SPRM.
Field Name: QWP4CDTSL
- 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.
Field Name: QWP4S1IL
- SIMULATED CPUS
- The number of CPUs that are online.
Field Name: QWP4NCPU
- MSEC OF TASK/SRB
- Microseconds of task or SRB (service request block)
execution time for each service unit (SU).
Field Name: QWP4CPUM
- COMPRESS SPT01
- Enables the compression of SPT01.
Field Name: QWP4CS01
- UT SORT DS ALLOC
- In DB2 12 this field is a serviceability field.
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
- MAX ZL DICT ENTR
- The maximum number of ZIVLEMPEL dictionary entries.
Field Name: QWP4MDE
- I/O SCHEDULING
- Determines whether the I/O scheduling feature is activated.
DB2 parameter SPRMIOP in DSN6SPRM.
Field Name: QWP4IOP
- UT DB2 SORT USE
- In DB2 12 this field is a serviceability field.
Enables the use of DB2 SORT.
Field Name: QWP4DB2SRT
- ENABLE DB CHECK
Enable database checking.
Field Name: QWP4DBCK
- IGN SORTNUM STMT
Ignores SORTNUM clause in utility control statements. The ZPARM name is IGNSORTN in DSN6SPRM.
Field Name: QWP4IGSN
- UT TEMP STORCLASS
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
- BIF COMPATIBILITY
- The BIF_COMPATIBILITY subsystem parameter
specifies whether the built-in functions and
specifications are to return results in the DB2 10 format
or revert to the pre-Version 10 format. It
can have the following values:
- CURRENT
- V9
- V9_TRIM
- V9_DECIMAL_VARCHAR (default for migration)
- N/P (default for new installation
This
field corresponds to field BIF COMPATIBILITY on installation panel
DSNTIPX.ZPARM name BIF_COMPATIBILITY in DSN6SPRM.Field Name: QWP4_BIF_COMPAT
- FAST REPLICATION
The FASTREPLICATION type for check utilities:
- N=NONE
- P=PREFERRED
- R=REQUIRED
This field corresponds to field "Fast replication" in installation panel DSNTIP6. The ZPARM name is CHECK_FASTREPLICATION in DSN6SPRM.
Field Name: QWP4CFRP
- 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
- CAT DAT DATACLASS
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
- FAST RESTORE
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 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
- CAT DAT MGMTCLASS
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
- RESTR ALT COL 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
- 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
- CAT DAT STORCLASS
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
- SET CHECK PENDING
- In DB2 12 this field is a serviceability field.
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
- FLASHCOPY REB IX
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
- CAT IDX DATACLASS
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
- DISABLE EDM RTS
Hexadecimal (X'01'). YES disables the use of EDM real-time Statistics. The ZPARM name is DISABLE_EDMRTS in DSN6SPRM.
Field Name: QWP4DEDR
- FLASHCPY 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
- CAT IDX MGMTCLASS
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
- DRDA RESOLV 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
- FLASHCPY REORG IX
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
- CAT IDX STORCLASS
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
- MANAGE REAL STOR
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
- 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
- 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
- REORDERD ROW FORM
- In DB2 12 this field is a serviceability field.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
- SEPAR WORK FILES
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
- PREVENT ALTER LMT
- Determines whether DB2 disallows altering the
limit key by using an ALTER TABLE statement for
index-controlled partitioned table spaces.
This alter operation places the table space in
REORG-pending (REORP) restrictive status,
and the data is not available until the affected
partitions are reorganized.
Use PREVENT_ALTERTB_LIMITKEY to avoid this data unavailability.
- NO
- Specifies that you can alter a limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. NO is the default.
- YES
- Specifies that it is not permitted to alter a limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. An ALTER TABLE statement must not attempt to alter the limit key for an index-controlled partitioned table.
Install parameter PREVENT ALTER LIMITKEY
on panel DSNTIP71, or ZPARM: PREVENT_ALTERTB_LIMITKEY
in DSN6SPRM.Field Name: QWP4PALK
- PREVENT IDX PART
- Determines whether DB2 does not allow the creation
of new
index-controlled partitioned tables.
This subsystem parameter ensures that new partitioned tables use
table-controlled partitioning,
which is the preferred partitioning method for non-universal
table spaces.
- NO
- Specifies that new index-controlled partitioned tables can be created. NO is the default value.
- YES
- Specifies that new partitioned table spaces must use table-controlled partitioning. A CREATE INDEX statement must not attempt to create an index-controlled partitioned table.
Install parameter PREVENT INDEX PART CREATE
on panel DSNTIP71, or ZPARM: PREVENT_NEW_IXCTRL_PART in DSN6SPRM.Field Name: QWP4PCIP
- RETRY STOPPED OBJ
- Specifies whether DB2 should immediately reject
requests for a stopped object or retry them, up to the IRLM timeout
limit, if the object is restarted.
- NO
- This is the default. It indicates that DB2 immediately rejects requests for a stopped object.
- YES
- DB2 retries such requests, up to the IRLM timeout setting, if the stopped object is restarted.
Install parameter RETRY STOPPED OBJECTS on panel
DSNTIP72, or ZPARM RETRY_STOPPED_OBJECTS in DSN6SPRM.Field Name: QWP4RSO
- EMPTY XML ELEMENT
- Indicates whether empty XML elements are serialized:
- NO
- Serialization of empty XML elements is not defined.
- YES
- Empty XML elements are serialized using a start-element tag followed by an end-element tag.
ZPARM name is XML_RESTRICT_EMPTY_TAG in DSN6SPRM.Field Name: QWP4NOET
- RENAME TABLE
- Specifies whether the RENAME TABLE statement
should extend to tables that are referenced in a
view definition or the definition of an SQL table function:
- YES
- ALLOW_DEP_VIEW_SQLTUDF
- NO
- DISALLOW_DEP_VIEW_SQLTUDF
Install parameter RENAME TABLE on panel DSNTIP72,
or ZPARM RENAMETABLE in DSN6SPRM.Field Name: QWP4ERTS
- ALTERNATE CPYPOOL
- Specifies an optional alternate SMS copy pool
for the DB2 BACKUP SYSTEM utility.This field corresponds to field ALTERNATE COPYPOOL on
INSTALLATION panel DSNTIP62. The ZPARM name is
ALTERNATE_CP in DSN6SPRM.
Field Name: QWP4BSACP
- DB BAK STG GRP
- Specifies an optional backup SMS storage group
to be used by the DB2 BACKUP SYSTEM utility
for the DB copy pool.This field corresponds to field DB BACKUP STG GROUP on
INSTALLATION panel DSNTIP62. The ZPARM name is UTIL_DBBSG
in DSN6SPRM.
Field Name: QWP4UDBSG
- LOG BAK STG GRP
- Specifies an optional backup SMS storage group to
be used by the DB2 BACKUP SYSTEM utility
for the LOG copy pool.This field corresponds to field LOG BACKUP STG GRP on
INSTALLATION panel DSNTIP62. The ZPARM name is
UTIL_LGBSG in DSN6SPRM.
Field Name: QWP4ULBSG
- COPY FAST REPLIC
- Specifies whether FlashCopy fast replication is
preferred, required,
or should not be used.This field corresponds to field COPY FAST REPLICATION on
INSTALLATION panel DSNTIP61. The ZPARM name is
COPY_FASTREPLICATION in DSN6SPRM.
Field Name: QWP4CYFR
- PAGE NUMBERING
- Specifies whether range-partitioned table spaces
and associated indexes will be created to use
absolute page numbers across partitions or relative page numbers.
- A
- Absolute page numbers
- R
- Relative page numbers
Install parameter PAGE SET PAGE NUMBERING on
panel DSNTIP71, or ZPARM PAGESET_PAGENUM in DSN6SPRM.Field Name: QWP4PSPN
- COMPRESS_DIRLOB
- Specifies whether DB2 compresses large
object (LOB) table spaces
in the DB2 directory the next time that the table spaces
are reorganized.
- 0 indicates NO
- 1 indicates YES
This value corresponds to field COMPRESS DB2 DIR LOBS
on installation panel DSNTIPA2.
ZPARM name: COMPRESS_DIRLOB in DSN6SPRM.Field Name: QWP4CDRL
- CACHE DYN STABIL
- Specifies when dynamic SQL statements can be captured
for stabilization.
When a statement is stabilized,
the current SQLID, statement text, and runtime structures are
written to catalog tables.
If a dynamic SQL statement is not present in the dynamic SQL
statement cache,
DB2 will load the runtime structures from
catalog table rather than performing a full prepare.
This extends the stability and reliability of performance
of a dynamic SQL.
It can have the following values:
- CAPTURE
- Statements may be stabilized through the -START DYNQUERY command using both MONITOR(NO) and MONITOR(YES). DB2 will not load stabilized statements from SYSDYNQRY.
- LOAD
- Statements may not be stabilized via any means. The -START DYNQUERY command will fail, and any MONITOR(YES) commands in progress will not stabilize statements, even if stabilization criteria are matched. During long prepare, DB2 will attempt to load stabilized statements from SYSDYNQRY with which to run.
- BOTH
- Statements may be stabilized through the -START DYNQUERY command via both MONITOR(NO) and MONITOR(YES). During long prepare, DB2 will attempt to load stabilized statements from SYSDYNQRY with which to run. BOTH is the default setting.
- NONE
- Statements may not be stabilized via any means. The -START DYNQUERY command will fail, and any MONITOR(YES) commands in progress will not stabilize statements, even if stabilization criteria are matched. DB2 will not load stabilized statements from SYSDYNQRY.
This field corresponds to field CACHE DYN STABILITY on installation panel DSNTIP8. The ZPARM name is CACHEDYN_STABILIZATION in DSNTIP8.
Field Name: QWP4CDST
- SELECT FOR UNLOAD
- Shows the AUTH_COMPATIBILITY ZPARM values (DB2 field: QWP4AUTCSU):
- 1
- The unload utility checks whether the user has the SELECT privilege on the target table.
- 0
- The unload utility checks whether the user has the UNLOAD privilege on the target table.
Field Name: QWP4ACSU
- DDL MATERIALIZATN
- Specifies when DB2 materializes changes to the definition
of an object. This value corresponds to field DDL
MATERIALIZATION on installation panel DSNTIP71.
ZPARM name is DDL_MATERIALIZATION in DSN6SPRM.
Field Name: QWP4DDLM
- INDEX MEMORY CTRL
- Shows the amount of memory that DB2 should allocate for fast
traversing of DB2 indexes:
- -1 = AUTO
- Specifies that DB2 sets the upper limit of the storage to 20% of the currently allocated buffer pools.
- 0 = DISABLE
- Specifies that DB2 returns any existing storage allocated for fast index traversal and does not allocate any further storage for this purpose.
- 500 - 200000
- Indicates the storage limit for fast index traversal.
The ZPARM name is INDEX_MEMORY_CONTROL in DSN6SPRM.
Field Name: QWP4IXMC
- HSM MSG DS HLQ
- Shows the high level qualifier (HLQ) for data sets (DS) to be
allocated by the DB2 BACKUP SYSTEM and
RESTORE SYSTEM utilities to receive messages from the
Data Facility Hierarchical Storage Manager (DFHSM) and the
IBM Data Facility Data Set Services (DFDSS) (DB2 field: QWP4UHMDH).This value corresponds to field
HSM MESSAGE DS HLQ on installation panel DSNTIP62.
ZPARM name: UTILS_HSM_MSGDS_HLQ in DSN6SPRM.
Field Name: QWP4UHMDH
- DFLT INSERT ALG
- Specifies the default algorithm for inserting data
into table spaces. This value corresponds to the field DEFAULT
INSERT
ALGORITHM on installation panel DSNTIP71.
The ZPARM name DEFAULT_INSERT_ALGORITHM is in DSN6SPRM.
Field Name: QWP4DINA
- STATFDBK PROFILE
- Specifies whether Statistics recommendations
that are identified during query optimization cause
DB2 to modify to Statistics profiles.
- 0 indicates NO
- 1 indicates YES
This value corresponds to field STATS PROFILE FEEDBACK
on installation panel DSNTIP8.
ZPARM name: STATFDBK_PROFILE in DSN6SPRM.Field Name: QWP4SFPR
- MAT NODET SQLTUDF
- DB2 materializes the result of a user-defined
SQL table function that is defined as not deterministic.
- 0=NO
- 1=YES
Field Name: QWP4MNSU