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 ..: QDA7IRLM            
TAB OWNER .......: DSNRGCOL              INST DD CTRL SUPT:                   NO  IRLM MODULE NAME : IRXC                
APPL TABLE ......: DSN_REGISTER_APPL     CTRL ALL APPLIC .:                   NO                                         
OBJ TABLE .......: DSN_REGISTER_OBJT     REQ FULL NAMES ..:                  YES  IRLM INIT TIME ..:                    1
INSTALL SYSADM ..: DB2SYSP               UNREGIST DDL DFLT:               ACCEPT                                         
SYSADM ID 2 .....: TSSAL                 UTILITY FACTOR ..:                    6  IRLM TIMEOUT ....:                   30
DEFAULT USERID ..: IBMUSER               EXPL AT AUTOBIND :                  YES  MAXIMUM DATASETS :                 3000
DATABASE NAME ...: DSNRGFDB              ASYNC DRAIN START:                    1                                         
SYSOPER ID ......: PDKURT                SITE TYPE .......:                LOCAL  ASYNC DRAIN STOP :                    3
SYSOPER ID 2 ....: TSSAL                 TRACKER SITE ....:                   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 ..:               100000  CACHE DYNAMIC SQL:                  YES
MFA UNUSED TIME..:                  600                                                                                  
AUTH CACHE SIZE .:                  N/A  REP READ U LOCK .:                  YES  MAX KEPT DYN STMT:                 5000
ACCEL MODELING ..:                   NO  MAX TSPACE LOCK .:                 1000  CURRENT DEGREE ..:                  ANY
OPT HINTS ALLOWED:                   NO  SORT POOL SIZE ..:             10240000  STATIC DESCRIBE .:                  YES
RIDPOOL SIZE (KB):                40000  MAX DEG OF PARALL:                    0                                         
USE X LOCK ......:                   NO                                           STAR JOIN ENABL .:              DISABLE
NPAGES THRESHOLD :                    1  DBADM CREATE VIEW:                  YES  MAX # LE TOKENS .:                  N/A
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 .:                  ALL
SUPPRESS SOFT ERR:                  YES  REAL TIME STATS .:                   15  EDM STATMNT CACHE:             58053632
STAR JOIN THRESH :                   10  ZOSMETRICS ......:                   NO  EDM DBD CACHE ...:             11980800
LONG RUNNING READ:                   10  MAX OPEN CURSORS :                  500  EDM SKEL POOLSIZE:             83886080
CUR MAINT TYPE ..:               SYSTEM  PAD IDX BY DEFLT :                   NO  MIN DIVIDE SCALE :                 NONE
FREE CACHED STMTS:                  N/A  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'                                                      
MAX TEMP STORAGE :                    0  ONL ZPARM CORID .: 'BLANK'               REVOKE DEP PRIVIL:                   NO
MAX CONC AUTOBIND:                   10  ONL ZPARM TIME ..:                      N/P                                     
PLANMGMT ........:                  OFF  ADM SCHED JCLPROC: 'BLANK'               SYS-LEVEL BACKUP :                   NO
PLANMGMTSCOPE ...:                  N/A  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:                  N/A
DDL TIMEOUT FACT :                    1  CUR QUERY ACCEL .:               ENABLE  REORG SORT NPSI .:                 AUTO
MAX UTIL PARALL .:                   99  ACCEL STARTUP OPT:              COMMAND  REORG IGN FREESPC:                  N/A
MULT INDEX ACCESS:                  N/A  ACCEL OPT. :                (1,2,3,5,6)  REORG TABSPC LIST:             PARALLEL
OPT 1 ROW-NO SORT:                  N/A  AUTH EXIT CHECK .:              PRIMARY  REORG MAPPING DB : 'BLANK'             
AUTHEX CACHE REF :                  ALL  REORG DROP PARTS :                   NO                                         
PKG RLEASE COMMIT:                  YES  REORG KEEP DICT .:                  N/A                                         
TEMPLATE TIME ...:                  UTC  MAX IN-MEM SORT .:                 2000  STATIST FEEDBACK :                  ALL
LOAD RO OBJECTS..:                  YES                                                                                  
MAX PARA DEG DPSI:                    0  APPL COMPAT .....: V13R1M504             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:                  N/A                                         
SIMULATED CPUS ..:                    0  MSEC OF TASK/SRB :                    0                                         
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: CURRENT               FAST REPLICATION :            PREFERRED
FLASHCOPY PPRC ..:             REQUIRED  CAT DAT DATACLASS: 'BLANK'               FAST RESTORE ....:            PREFERRED
FLASHCOPY COPY ..:                   NO  CAT DAT MGMTCLASS: 'BLANK'               RESTR ALT COL DCC:                   NO
FLASHCOPY LOAD ..:                   NO  CAT DAT STORCLASS: 'BLANK'               SET CHECK PENDING:                   NO
FLASHCOPY REB IX :                   NO  CAT IDX DATACLASS: 'BLANK'               DISABLE EDM RTS .:                   NO
FLASHCPY REORG TS:                   NO  CAT IDX MGMTCLASS: 'BLANK'               DRDA RESOLV ALIAS:                  YES
FLASHCPY REORG IX:                   NO  CAT IDX STORCLASS: 'BLANK'               MANAGE REAL STOR :                  N/A
MAX REAL+AUX STOR:                    0  PARALL EFFICIENCY:                  N/A  REORDERD ROW FORM:                  YES
SEPAR WORK FILES :                   NO  PREVENT ALTER LMT:                   NO  PREVENT IDX PART :                   NO
RETRY STOPPED OBJ:                   NO  EMPTY XML ELEMENT:                   NO  RENAME TABLE     :                   NO
ALTERNATE CPYPOOL:     'BLANK'           DB BAK STG GRP   :             'BLANK'   LOG BAK STG GRP  :             'BLANK' 
COPY FAST REPLIC :            PREFERRED  PAGE NUMBERING   :             ABSOLUTE  COMPRESS_DIRLOB  :                   NO
CACHE DYN STABIL :                 BOTH  SELECT FOR UNLOAD:                   NO  DDL MATERIALIZATN:     ALWAYS_IMMEDIATE
INDEX MEMORY CTRL:                 AUTO  HSM MSG DS HLQ   :             'BLANK'   DFLT INSERT ALG  :                    1
STATFDBK PROFILE :                  YES  MAT NODET SQLTUDF:                   NO  ACCEL WT FOR DATA:                  0.0
ZHYPERLINK       :              DISABLE  SUBSTRING COMPAT.:             PREVIOUS  LOAD IMPL. SCALE :                   NO
FTB NON UNQE IDX :                   NO  UTILITY HISTORY  :              'BLANK'  LONG COLU. NAMES :                  YES
REORG IC LI. DASD:                    0  REORG IC LI. TAPE:                    0  REORG I. NOSYSUT1:                   NO
UTILS USE ZSORT  :                   NO  BLOCK UTILS CDC  :                   NO  LOCK TIMEOUT MAX :                   -1
ALLOW U/D/I W. UR:                   NO  DISALLOW SSAR    :                  YES  REORG TS NOPAD DF:                  YES
STATCLGSRT       :                   10  STATPGSAMP       :               SYSTEM  IX MEM CT STR LIM:                  N/A
MAX USER DEF FUNC:                 2000  LOCK AV SINGLESEL:                   NO  MAX MEM FOR AI   :                    0


LIST OF LONG NAMES                                                                                                       
FCOPY DEFLT TEMPL: QDS7.&DB..&SN..N&DS..D&JU..T&TI.                                                                      
ENCRYPTION KEY...: N/P                                                                                                   
                                                                                                                         
QWP4LEN .........:                 2884  QWP4EYE .........: SPRM                  QWP4LVL .........: DSN1310             
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 ........:                 2864
QWP4DBOF ........:                 2852  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 ........:                  900  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 ........:                  180  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 ........:                    2
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 ........:             11/03/23  QWP4AURT ........:                   50  QWP4DXTP ........:                    2
QWP4MXTB ........:                  225  QWP4CTHR ........:                   10  QWP4STHR ........:              1048576
QWP4SREC ........:              X'8000'  QWP4RMTI ........:                    1  QWP4MXCE ........:                 1023
QWP4INLP ........:                 1000  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 ........:                  YES
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  QWP4ACNPTSRCH....:                   NO  QWP4DCNPTSRCH....:                   NO
QWP4LOBDIAG .....:                   NO  QWP4IXSAT .......:                 1000  QWP4PKGDEPLVL....:              PACKAGE
QWP4IMPLCAST ....:                   NO  QWP4POOLCONTRACT.:                   NO  QWP4PRLD.........:                    0
QWP4QA92.........:                   NO  QWP4QA93.........:                   NO  QWP4QA94.........:                   NO
QWP4ISWT.........:                  120  QWP4IAUT.........:                  YES  QWP4CDC..........:                   NO
QWP4ENF..........:                   NO  QWP4PAC..........:             10485760  QWP4CONT.........:                   NO
QWP4RAC..........:             10485760  QWP4IIOP.........:                  YES  QWP4UTOC1........:                  YES
QWP4UTOC2........:                  YES  QWP4OBCF.........:                  YES  QWP4S1IL ........:                32138
QWP4CS01.........:                  YES  QWP4DPRHWV.......:                   NO  QWP4INLHASH......:                    0  
QWP44KSMALL......:                   16  QWP44KMEDIUM.....:                  880  QWP432KSMALL.....:                   16
QWP432KMEDIUM....:                  880

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

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.

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

SYSADM ID 2

One of two authorization IDs with SYSADM authority. SYSADM users can access to Db2 in all cases.

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.

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

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.

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.

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

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. Possible 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

MFA UNUSED TIME

MFA UNUSED TIME specifies how long in seconds that MFA security credentials from a distributed client can remain unused in the Db2 global authentication cache before new security credentials must be provided.

Field Name: QWP4MFAT

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

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

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.

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

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 non-phase-in automatic bind requests, remote bind requests, remote rebind requests, CREATE TRIGGER statements, and CREATE PROCEDURE statements for packages that can be processed simultaneously. The maximum number of autobind phase-in 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

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.
8: Favor new ACCELERATOR_TYPE.
9: Enable uncertainty cost estimation.
10: Balance workload between versions.
11: Use only new ACCELERATOR_TYPE.
12: In predicate with more than 32K elements.
13: Enable accelarator specific results.

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.

The access control authorization exit uses the ACEE for the XAPLUCHK authorization ID field to perform the authorization. The authorization ID in XAPLUCHK must be defined as a RACF user and must have the privileges required to execute the SQL statements in the package.

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

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

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

LOAD RO OBJECTS

Specifies whether the load utility is allowed to load data into read-only target objects. Possible values are:

YES: Db2 utilities allow LOAD with any SHRLEVEL option to load into read-only objects.
NO: Db2 utilities disallow LOAD with any SHRLEVEL option to load into read-only objects.

Background and Tuning Information

The LOAD RO OBJECTS subsystem parameter specifies whether Db2 utilities allow LOAD on all SHRLEVELs including the data loading and inserting cases to load into read-only (RO) objects.

Field Name: QWP4LIRO

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

SIMULATED CPUS

The number of CPUs that are online.

Field Name: QWP4NCPU

MSEC OF TASK/SRB

Specifies the microseconds of task or service request block (SRB) execution time per service unit for the simulated CPU. Use this field only for Db2 optimization modeling. A value of 0 represents OFF, which is the default. OFF indicates that Db2 optimizes for the actual CPU that it runs on and is recommended for Db2 production environments.

Before Db2 10, this field indicated the number of TCB or SRB CPU microseconds per service unit (SRU).

Field Name: QWP4CPUM

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

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

ZPARM name is MATERIALIZE_NODET_SQLTUDF in DSN6SPRM.

Field Name: QWP4MNSU

ACCEL WT FOR DATA

Beginning with IDAA V5 PTF 6, a query can optionally wait for replication to complete instead of failing if the necessary data is not available in the accelerator. The default value for the SET CURRENT QUERY ACCELERATION WAITFORDATA special register is controlled by the QUERY_ACCEL_WAITFORDATA system parameter. The value range is 0.0 to 3600.0 seconds.

Field Name: QWP4QAWFD

ZHYPERLINK

Specifies how Db2 uses z/OS zHyperLinks, which are used for synchronous I/O connections to Media Manager. In Db2 data sharing, it is recommended to use the same setting for all group members.

This field is new in Db2 12.

Background and Tuning Information

Valid values are:

DISABLED: zHyperLink I/O not used by this subsystem. This is default value.
ENABLED: Db2 requests zHyperLink protocol for all of eligible I/O requests to Media Manager.
DATABASE: Db2 requests zHyperLink protocol only for database synchronous read I/Os.
ACTIVELOG: zHyperLink will only be used for eligible I/O on active log objects.

Field Name: QWP4ZHYPL

SUBSTRING COMPAT.

Specifies whether the SUBSTR built-in function returns error when the length argument of the function violat this documented rule: the value must be greater than or equal to 0 and less than or equal to n, where n is the length attribute of string-expression - start + 1. The values are:

PREVIOUS: An error is not returned.
CURRENT: An error is returned.

This value corresponds to field SUBSTR COMPATIBILITY on installation panel DSNTIPX. ZPARM name: SUBSTR_COMPATIBILITY in DSN6SPRM.

Field Name: QWP4SUBSTRCP

LOAD IMPL. SCALE

Specifies how the load utility with the format delimit option processes decimal data that does not contain a explicit decimal point.

YES: The decimal point is determined from the scale that is specified in the field specification in the load utility control statement.
NO: The decimal point is placed to the right of the rightmost digit of the number.

This value corresponds to field load format delimited implicit dec scale on installation panel DSNTIP63. ZPARM name: LOAD_DEL_IMPLICIT_SCALE in DSN6SPRM.

Field Name: QWP4LDISCALE

FTB NON UNQE IDX

Fast index traversal for non-unique indexes is enabled when index_memory_control is enabled.

YES

NO

This value corresponds to field FTB NON UNIQUE INDEX installation panel DSNTIP71. ZPARM name: FTB_NON_UNIQUE_INDEX in DSN6SPRM.

Field Name: QWP4FTBUO

UTILITY HISTORY

Utility history.

Field Name: QWP4UTHIST

LONG COLU. NAMES

Use long column names.

Field Name: QWP4TCNE

REORG IC LI. DASD

Specifies the maximum number of sequential DASD image copies that the reorg tablespace utility can allocate. This value corresponds to field REORG IC LIMIT DASD on installation panel DSNTIP63. ZPARM name: REORG_IC_LIMIT_DASD in DSN6SPRM.

Field Name: QWP4RICLD

REORG IC LI. TAPE

Specifies the maximum number of sequential tape image copies that the reorg tablespace utility can allocate. This value corresponds to field REORGI IC LIMIT TAPE on installation panel DSNTIP63. ZPARM name: REORG_IC_LIMIT_TAPE in DSN6SPRM.

Field Name: QWP4RICLT

REORG I. NOSYSUT1

Specifies whether the reorg index utility avoids using the sysut1 data set or a specified work data set to hold unloaded index keys.

YES: Reorg index avoids using the sysut1 data set or a specified work data set to hold unloaded index keys.
NO: Reorg index uses the sysut1 data set or a specified work data set to hold unloaded index keys.

This value corresponds to field REORG INDEX NOSYSUT1 on installation panel DSNTIP63. ZPARM name: REORG_INDEX_NOSYSUT1 in DSN6SPRM.

Field Name: QWP4RINSU

UTILS USE ZSORT

Specifies whether Db2 utilities attempt to use the IBM integrated accelerator for z sort interface when the utilities invoke DFSORT for their processing.

YES: Db2 utilities attempt to use the IBM integrated accelerator for z sort interface.
NO: Db2 utilities do not attempt to use the IBM integrated accelerator for z sort interface.

This value corresponds to field UTILS USE ZSORT on installation panel DSNTIP63. ZPARM name: UTILS_USE_ZSORT in DSN6SPRM.

Field Name: QWP4UZS

BLOCK UTILS CDC

Specifies whether certain Db2 utilities are blocked from running on tables with replication enabled, or on table spaces that contain those tables.

YES: Utilities are blocked.
NO: Utilities are not blocked.

This value corresponds to field UTILS BLOCK FOR CDC on installation panel DSNTIP6. ZPARM name: UTILS_BLOCK_FOR_CDC in DSN6SPRM.

Field Name: QWP4UBCDC

LOCK TIMEOUT MAX

Specifies valid values for the CURRENT LOCK TIMEOUT statement. Possible values are:

-1: Any supported value can be specified.
0 to 32767: The maximum value that can be specified. This value corresponds to field.

This value corresponds to field LOCK TIMEOUT MAX on installation panel DSNTIPI. ZPARM name: SPREG_LOCK_TIMEOUT_MAX in DSN6SPRM.

Field Name: QWP4LTMX

ALLOW U/D/I W. UR

Specifies if Db2 executes a PREPARE of an INSERT, UPDATE, or DELETE statement, Db2 allows the isolation clause of the INSERT, UPDATE, or DELETE statement to include the WITH UR clause. ZPARM name: ALLOW_UPD_DEL_INS_WITH_UR in DSN6SPRM.

Field Name: QWP4AUDIWU

DISALLOW SSAR

Disallow SSAR authorization.

Field Name: QWP4DSSAR

REORG TS NOPAD DF

Specifies the default setting for the NOPAD option of the reorg tablespace unload external or discard specification. Possible values are:

YES: The default is NOPAD.
NO: The default is not NOPAD.

This value corresponds to field REORG TS NOPAD DEFAULT on installation panel DSNTIP63. ZPARM name: REORG_TS_NOPAD_DEFAULT in DSN6SPRM.

Field Name: QWP4RTNP

STATCLGSRT

Specifies the default setting for the NOPAD option of the reorg tablespace unload external or discard specification. Possible values are:

YES: The default is NOPAD.
NO: The default is not NOPAD.

This value corresponds to field REORG TS NOPAD DEFAULT on installation panel DSNTIP63. ZPARM name: REORG_TS_NOPAD_DEFAULT in DSN6SPRM.

Field Name: QWP4STACS

STATPGSAMP

Specifies the default setting for the NOPAD option of the reorg tablespace unload external or discard specification. Possible values are:

YES: The default is NOPAD.
NO: The default is not NOPAD.

This value corresponds to field REORG TS NOPAD DEFAULT on installation panel DSNTIP63. ZPARM name: REORG_TS_NOPAD_DEFAULT in DSN6SPRM.

Field Name: QWP4STPGS

IX MEM CT STR LIM

Specifies the default setting for the NOPAD option of the reorg tablespace unload external or discard specification. Possible values are:

YES: The default is NOPAD.
NO: The default is not NOPAD.

This value corresponds to field REORG TS NOPAD DEFAULT on installation panel DSNTIP63. ZPARM name: REORG_TS_NOPAD_DEFAULT in DSN6SPRM.

Field Name: QWP4IXMCS

MAX USER DEF FUNC

Determines the maximum number of user-defined external scalar functions that can run concurrently in a Db2 thread. Valid entry is an integer between 0 and 99999 inclusive. The default is 2000.

Field Name: QWP4MXUDF

LOCK AV SINGLESEL

Specifies whether Db2 enables lock avoidance for singleton SELECT with ISOLATION(CS) CURRENTDATA(YES). Possible values are:

YES: Db2 enables lock avoidance for singleton SELECT with ISOLATION(CS) CURRENTDATA (YES).
NO: Db2 disables lock avoidance for singleton SELECT with ISOLATION(CS) CURRENTDATA (YES). This is the default setting.

Field Name: QWP4LSSIC

MAX MEM FOR AI

Specifies the maximum memory in MB for AI data caching per thread. Valid values are in the range 0 - 512.

Field Name: QWP4MXAIDC

QWP4IAUT