DSNZPARMs At installation time you supply values for the DB2 DSNZPARM parameters via the install panels. Table 2-1 lists all the DSNZPARMs, along with a description of each, the allowable values, and whether they can be changed online. Table 2-1. DSNZPARMsParameter | Description | Acceptable Values (defaults are in boldface) | Online Updatable |
|---|
ABEXP | EXPLAIN processing | YES, NO | Yes | ABIND | Autobind | YES, NO | Yes | ACCUMACC | DDF/RRSAF accumulated data | NO, 265,535 10 | Yes | AGCCSID | ASCII-coded character set (graphic) | 065,533 | | ALCUNIT | Allocation units | BLK, TRK, CYL | Yes | ALL/dbname | Start names | ALL, space names | | AMCCSID | ASCII-coded character set (mixed) | 065,533 | | APPENSCH | Application encoding | ASCII, EBCDIC, Unicode, CCSID | | ARCPFX1 | Copy 1 prefix | 134 characters | Yes | ARCPFX2 | Copy 2 prefix | 134 characters | Yes | ARCRETN | Retention period | 09,999 | Yes | ARCWRTC | WTOR route code | 116 1,3,4 | Yes | ARCWTOR | Write to operator | NO, YES | Yes | ARC2FRST | Read Copy 2 archive | NO, YES | Yes | ASCCSID | ASCII-coded character set (single byte) | 065,533 | | ASSIST | Assistant | YES, NO | No | AUDITST | Audit trace | NO, YES, list, * | No | AUTH | Use protection | YES, NO | No | AUTHCACH | Plan authorization cache | 04,096 3,072 | Yes | BACKODUR | Backout duration | 0255 5 | No | BINDNV | Bind new package | BINDADD, BIND | Yes | BLKSIZE | Block size | 8,19228,672 24,576 | Yes | BMPTOUT | IMS BMP Timeout | 1254 4 | Yes | CACHEDYN | Cache dynamic SQL | NO, YES | Yes | CACHEPAC | Package authorization cache | 02M 32K | No | CACHERAC | Routine authorization cache | 02M 32K | No | CATALOG | Catalog alias | 18 characters DSNCAT | Yes | CDSSRDEF | Current degree | 1, ANY | Yes | CHARSET | CCSID used | ALPHANUM, KATAKANA (if SCCSID = 930 or 5,026) | | CHKFREQ | Checkpoint frequency | 20016M records (500K), or 160 minutes | Yes | CHGDC | Drop support | 1,2,3 | Yes | CMTSTAT | DDF threads | ACTIVE, INACTIVE | No | COMPACT | Compact data | NO, YES | Yes | COMPAT | IBM service | OFF | | CONDBAT | Maximum remote connected | 025,000 10,000 | Yes | CONTSTOR | Contract thread storage | NO, YES | Yes | COORDNTR | Coordinator | NO, YES | No | CTHREAD | Maximum users | 12,000 200 | Yes | DBACRVW | DBADM can create view for other authid | YES, NO | Yes | DBPROTCL | Database protocol | DRDA, Private | Yes | DATE | Date format | ISO, USA, EUR, JIS, LOCAL | | DATELEN | Local date length | 0, 10 254 | | DDF | DDF start-up option | NO, AUTO, COMMAND | No | DEALLCT | Deallocate period | 01,439 minutes, 059 seconds, NOLIMIT | Yes | DECARTH | Decimal arithmetic | DEC15, DEC31, 15, 31 | | DECDIV3 | Minimum divide scale | NO, YES | No | DECIMAL | Decimal point | , . | | DEFLANG | Language default | ASM, C, CPP, COBOL, COB2, IBMCOB, FORTRAN, PL1 | | DEFLTID | Unknown authid | IBMUSER, or authid | No | DELIM | String delimiter | DEFAULT, ", ' | | DESCSTAT | Describe for static | NO, YES | Yes | DISABSCL | SQLWARN1 and 5 for nonscrollable cursors | NO, YES | | DLDFREQ | Level ID update frequency | 032,767 5 | Yes | DLITOUT | DL/I batch timeout | 1254 6 | Yes | DSHARE | Data sharing | YES, NO, blank | No | DSMAX | Data set maximum | 1100,000 | Yes | DSQLDELI | Dist SQL string delimiter | ', '' | | DSSTIME | Data set stats time | 11,440 5 | Yes | DSCVI | Vary DS control interval | YES, NO | | DYNRULES | Use for dynamic rules | YES, NO | | EDMBFIT | Algorithm for free chain search | YES, NO | Yes | EDMDBDC | EDM DBD cache | 5,0002,097,152K | Yes | EDMPOOL | EDMPOOL storage size | 1K2,097,152K 32,768 | Yes | EDMSTMTC | EDM statement cache size | 01,048,576K 5,000 | Yes | EDPROP | Drop support | 1, 2, 3 | Yes | ENSCHEME | Default encoding scheme | EBCDIC, ASCII | | EVALUNC | Predicate evaluation with UR and RS | YES, NO | Yes | EXTRAREQ | Extra blocks requester | 0100 | Yes | EXtrASRV | Extra blocks server | 0100 | Yes | EXTSEC | Extended security | NO, YES | Yes | GCCSID | EBCDIC coded character set (graphic byte) | 065,533 | | GRPNAME | Group name | 18 characters DSNCAT | No | HOPAUTH | Authorization at hop site | BOTH, RUNNER | No | IDBACK | Maximum batch connect | 12,000 50 | Yes | IDFORE | Maximum TSO connect | 12,000 50 | Yes | IDTHTOIN | Idle thread timeout | 09,999 120 | Yes | IDXBPOOL | Default buffer pool for user indexes | BP0BPx | Yes | IMMEDWRI | Immediate write | NO, YES, PH1 | Yes | IRLMAUT | Autostart | YES, NO | No | IRLMPRC | Procedure name | IRLMPROC, IRLM proc name | No | IRLMRWT | Resource timeout | 13,600 60 | No | IRLMSID | Subsystem name | IRLM, IRLM name | No | IRLMSWT | Time to autostart | 13,600 | Yes | IXQTY | Index space default size | 04,194,304 | Yes | LBACKOUT | Postpone backward log processing | AUTO, YES, NO | No | LC_CTYPE | Locale LC_CTYPE | Valid locale 050 characters | | LEMAX | Maximum LE Tokens | 050, 20 | No | LOBVALA | User LOB value storage | 12,097,152 10,240 | Yes | LOBVALS | User LOB value storage | 1510,002 2,048 | Yes | LOGAPSTG | Log apply storage | 1100M 100 | No | LRDRTHLD | Long-running reader threshhold | 01,439 minutes | Yes | MAINTYPE | Current maintenance types for MQTs | NONE, SYSTEM, USER, ALL | Yes | MAXARCH | Recording maximum | 101,000 | No | MAXDBAT | Maximum remote active | 01,999 200 | Yes | MAX_NUM_CUR | Maximum open cursors | 099,999 500 | Yes | MAXKEEPD | Maximum kept dynamic statements | 065,535 5000 | Yes | MAXRBLK | RID pool size | 0, 16K1,000,000K calculated | Yes | MAXRTU | Read tape units | 199 2 | Yes | MAX_ST_PROC | Maximum number of stored procedures | 099,999 2,000 | Yes | MAXTYPE1 | Maximum Type 1 inactive | 0MAX REMOTE CON | Yes | MCCSID | EBCDIC coded character set (mixed byte) | 065,533 | | MEMBNAME | Member name | 18 characters DSN1 | No | MGEXTSZ | Optimize extent sizing | YES, NO | Yes | MINDVSCL | Minimum scale for decimal division | NONE, 3, 6 | | MINRBLK | Number of RID lists for each RID map | 1, n | | MINSTOR | Thread management | YES, NO | Yes | MIXED | Mixed data | NO, YES | | MON | Monitor trace | NO, YES | No | MONSIZE | Monitor size | 8K to 1M | No | NPGTHRSH | Use of index after table growth | 0, 1, n | Yes | NUMLKTS | Locks per table space | 050,000 1,000 | Yes | NUMLKUS | Locks per user | 0100,000 10,000 | Yes | OFFLOAD | Offload active logs online | NO, YES | | OJPERFEH | Disable outer join performance enhancements | | Yes | OPTPREF | | ON, OFF | | OPTHINTS | Optimization hints | NO, YES | Yes | OUTBUFF | Output buffer | 40K400MB 400K | No | PADIX | Pad index by default | YES, NO | Yes | PADNTSTR | Pad null-terminated strings | YES, NO | Yes | PARAMDEG | Degree of parallelism | 0no upper limit | Yes | PARTKEYU | Allow partitioning keys to be updated | YES, NO, or same | Yes | PCLOSEN | Read-only switch checkpoints | 132,767 5 | Yes | PCLOSET | Read-only switch time | 132,767 10 | Yes | POOLINAC | Pool thread timeout | 09,999 120 | Yes | PRIQTY | Primary quantity | Blank, 19,999,999 | Yes | PROTECT | Archive logs protected with RACF | NO, YES | Yes | PTASKROL | Include accounting traces for parallel tasks | YES, NO | Yes | QUIESCE | Quiesce period | 0999 5 | Yes | RECALL | Recall database | YES, NO | No | RECALLD | Recall delay | 032,767 120 | Yes | REFSHAGE | Current refresh age | 0, ANY | Yes | RELCURHL | Release locks | YES, NO | Yes | RESTART/DEFR | Restart or defer | RESTART, DEFER | | RESYNC | Resync interval | 1, 2 99 | Yes | RETLWAIT | Retained lock timeout | 0254 | Yes | RETVLCFK | Varchar from index | NO, YES | Yes | RGFCOLID | Registration owner | 18 characters DSNRGCOL | No | RGFDBNAM | Registration database | 18 characters DSNRGFDB | No | RGFDEDPL | Control all applications | NO, YES | No | RGFDEFLT | Unregistered DDL default | APPL, ACCEPT, REJECT | No | RGFESCP | ART/ORT escape character | Nonalphanumeric character | No | RGFFULLQ | Require full names | YES, NO | No | RGFINSTL | Install DD control support | NO, YES | No | RGFNMORT | OBJT registration table | 117 characters DSN_REGISTER_OBJT | No | RGFNMPRT | APPL registration table | 117 characters DSN_REGISTER_APPL | No | RLF | RLF autostart | NO, YES | No | RLFAUTH | Resource Authid | SYSIBM, or authid | Yes | RLFERR | RLST access error | NOLIMIT, NORUN,150,000,000 | Yes | RLFERRD | RLST access error | NOLIMIT, NORUN,150,000,000 | Yes | RLFTBL | RLST name suffix | 01, 2 alphanumeric characters | Yes | ROUTCDE | WTO route codes | 1, 114 route codes | No | RRULOCK | U lock for RR/RS | NO, YES | Yes | SCCSID | EBCDIC coded character set (single byte) | 065,533 | | SECQTY | Secondary quantity | Blank, CLIST calculated, 19,999,999 | Yes | SECLCACH | | | | SEQCACH | Sequential cache | BYPASS, SEQ | Yes | SEQPRES | Utility cache option | NO, YES | Yes | SITETYP | Site type | LOCALSITE, RECOVERYSITE | No | SJMXPOOL | Star join maximum pool | 01,024 20 | Yes | SJTABLES | Number of tables in star join | | Yes | SMFACCT | SMF accounting | NO, YES(1), list (15,7,8), * | No | SMFSTAT | SMF statistics | YES (1,3,4), NO, list(15) , * | No | SMSDCFL | SMS data class for file table space | Blank, 18 characters | Yes | SMSDCIX | SMS data class for index table space | Blank, 18 characters | Yes | SPRMEDX | | | Yes | SPRMLTD | Size threshhold for compression | 10 | | SQLDELI | SQL string delimiter | Default, ', " | | SRTPOOL | Sort pool size | 240K64,000K | Yes | SSID | Subsystem name | DSN, SSID | | STARJOIN | Enabling star join | Disable, enable, 1, 232,768 | Yes | STATHIST | Collect historical statistics | SPACE, NONE, ALL, ACCESSPATH | Yes | STATSINT | Time to write RTS stats | 11,440 minutes 30 | Yes | STATROLL | Run stats aggregates partition-level statistics | YES, NO | Yes | STATIME | Statistics time | 11,440 minutes 30 | Yes | STDSQL | Standard SQL language | NO, YES | | STORMXAB | Maximum abend count | 0225 | Yes | STORPROC | DB2 procedure name | 18 characters ssnmSPAS | No | STORTIME | Timeout value | 51,800 seconds 180 | Yes | SUPERRS | Suppress logrec recording during soft errors | YES, NO | Yes | SVOLARC | Single volume | YES, NO | Yes | SYNCVAL | Statistics sync | NO, 059 | Yes | SYSADM | System administrator 1 | SYSADM or authid | Yes | SYSADM2 | System administrator 2 | SYSADM or authid | Yes | SYSOPR1 | System operator 1 | SYSOPR or authid | Yes | SYSOPR2 | System operator 2 | SYSOPR or authid | Yes | TBSBPOOL | Default buffer pool for user data | BP0 BPx | Yes | TCPALVER | TCP/IP already verified | NO, YES | Yes | TCPKPALV | TCP/IP keep alive | ENABLE, DISABLE, 165,524 120 | Yes | TIME | Time format | ISO, JIS, USA, EUR, LOCAL | | TIMELEN | Local time length | 0, 8254 | | trACLOC | Size of local trace table | 16 (4K bytes) | | trACSTR | Trace autostart | NO, YES (13), list (19) | No | TRACTBL | Trace size | 4396K 64K | No | TRKRSITE | Remote tracker site usage | NO, YES | No | TSQTY | Define allocation for table space | 04,194,304 | Yes | TSTAMP | Timestamp archives | NO, YES | Yes | TWOACTV | Number of active copies | 2, 1 | No | TWOARCH | Number of archive copies | 2, 1 | No | TWOBSDS | Number of BSDSs | YES, NO | | UGCCSID | Unicode CCSID (graphic) | 1,208 | | UIFCIDS | Unicode IFCIDS | YES, NO | Yes | UMCCSID | Unicode CCSID (mixed) | 1,208 | | UNIT | Device Type 1 | TAPE or any device | Yes | UNIT2 | Device Type 2 | Device or unit name | Yes | URCHKTH | UR check frequency | 0255 | Yes | URLGWTH | UR log write check | 01,000K | Yes | USCCSID | Unicode CCSID (single byte) | 1,208 | | UTIMOUT | Utility timeout | 1254 | Yes | VOLTDEVT | Temporary unit name | SYSDA, valid name | Yes | WLMENV | WLM environment | Valid name, 118 characters | Yes | XLKUPDT | X Lock for searched U/D | YES, NO | Yes |
After installation, these DSNZPARMs can be changed without your having to go back through the installation process. You can do this by changing the DSNTIJUZ member and reassembling and bouncing the DB2 subsystem, or performing an online change, for them to take effect. Online DSNZPARMs DB2 also allows for about 123 of the most popular DSNZPARMs to be dynamically changed without your having to stop and restart the DB2 subsystem and thereby cause an unwanted outage. The advantage to changing DSNZPARMs dynamically is to be able to tailor parameters to the current workload. For example, an approved change to the Environmental Descriptor Manager pool size can be implemented sooner without a DB2 outage. It may also be desirable to change not only buffer pool size but also EDM pool size and checkpoint frequency for overnight batch processing. The DSNZPARM member is changed dynamically in its entirety by activating a different DSNZPARM member. The SET SYSPARM command is used from a z/OS console, a DSN session under TSO, a DB2I panel, a CICS or IMS terminal or via an application or product using the Instrumentation Facility. The issuer must have SYSADM, SYSCTRL, or SYSOPR authority; for more on these authorities, refer to Chapter 3. The following forms of the SET SYSPARM statement can be used for controlling dynamic DSNZPARM settings: -SET SYSPARM LOAD (modname) Loads the named parameter module Default is DSNZPARM -SET SYSPARM RELOAD Last named subsystem parameter module is loaded into storage -SET SYSPARM STARTUP Loads the initial parameters from DB2 startup
|
