Home > Articles > Home & Office Computing > Mac OS X

  • Print
  • + Share This
This chapter is from the book

System Parameters

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

Parameter

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, 2–65,535 10

Yes

AGCCSID

ASCII-coded character set (graphic)

0–65,533

ALCUNIT

Allocation units

BLK, TRK, CYL

Yes

ALL/dbname

Start names

ALL, space names

AMCCSID

ASCII-coded character set (mixed)

0–65,533

APPENSCH

Application encoding

ASCII, EBCDIC, Unicode, CCSID

ARCPFX1

Copy 1 prefix

1–34 characters

Yes

ARCPFX2

Copy 2 prefix

1–34 characters

Yes

ARCRETN

Retention period

0–9,999

Yes

ARCWRTC

WTOR route code

1–16 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)

0–65,533

ASSIST

Assistant

YES, NO

No

AUDITST

Audit trace

NO, YES, list, *

No

AUTH

Use protection

YES, NO

No

AUTHCACH

Plan authorization cache

0–4,096 3,072

Yes

BACKODUR

Backout duration

0–255 5

No

BINDNV

Bind new package

BINDADD, BIND

Yes

BLKSIZE

Block size

8,192–28,672 24,576

Yes

BMPTOUT

IMS BMP Timeout

1–254 4

Yes

CACHEDYN

Cache dynamic SQL

NO, YES

Yes

CACHEPAC

Package authorization cache

0–2M 32K

No

CACHERAC

Routine authorization cache

0–2M 32K

No

CATALOG

Catalog alias

1–8 characters DSNCAT

Yes

CDSSRDEF

Current degree

1, ANY

Yes

CHARSET

CCSID used

ALPHANUM, KATAKANA (if SCCSID = 930 or 5,026)

CHKFREQ

Checkpoint frequency

200–16M records (500K), or 1–60 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

0–25,000 10,000

Yes

CONTSTOR

Contract thread storage

NO, YES

Yes

COORDNTR

Coordinator

NO, YES

No

CTHREAD

Maximum users

1–2,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

0–1,439 minutes, 0–59 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

0–32,767 5

Yes

DLITOUT

DL/I batch timeout

1–254 6

Yes

DSHARE

Data sharing

YES, NO, blank

No

DSMAX

Data set maximum

1–100,000

Yes

DSQLDELI

Dist SQL string delimiter

', ''

DSSTIME

Data set stats time

1–1,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,000–2,097,152K

–Yes

EDMPOOL

EDMPOOL storage size

1K–2,097,152K 32,768

Yes

EDMSTMTC

EDM statement cache size

0–1,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

0–100

Yes

EXTRASRV

Extra blocks server

0–100

Yes

EXTSEC

Extended security

NO, YES

Yes

GCCSID

EBCDIC coded character set (graphic byte)

0–65,533

GRPNAME

Group name

1–8 characters DSNCAT

No

HOPAUTH

Authorization at hop site

BOTH, RUNNER

No

IDBACK

Maximum batch connect

1–2,000 50

Yes

IDFORE

Maximum TSO connect

1–2,000 50

Yes

IDTHTOIN

Idle thread timeout

0–9,999 120

Yes

IDXBPOOL

Default buffer pool for user indexes

BP0–BPx

Yes

IMMEDWRI

Immediate write

NO, YES, PH1

Yes

IRLMAUT

Autostart

YES, NO

No

IRLMPRC

Procedure name

IRLMPROC, IRLM proc name

No

IRLMRWT

Resource timeout

1–3,600 60

No

IRLMSID

Subsystem name

IRLM, IRLM name

No

IRLMSWT

Time to autostart

1–3,600

Yes

IXQTY

Index space default size

0–4,194,304

–Yes

LBACKOUT

Postpone backward log processing

AUTO, YES, NO

No

LC_CTYPE

Locale LC_CTYPE

Valid locale 0–50 characters

LEMAX

Maximum LE Tokens

0–50, 20

No

LOBVALA

User LOB value storage

1–2,097,152 10,240

Yes

LOBVALS

User LOB value storage

1–510,002 2,048

Yes

LOGAPSTG

Log apply storage

1–100M 100

No

LRDRTHLD

Long-running reader threshhold

0–1,439 minutes

–Yes

MAINTYPE

Current maintenance types for MQTs

NONE, SYSTEM, USER, ALL

Yes

MAXARCH

Recording maximum

10–1,000

No

MAXDBAT

Maximum remote active

0–1,999 200

Yes

MAX_NUM_CUR

Maximum open cursors

0–99,999 500

Yes

MAXKEEPD

Maximum kept dynamic statements

0–65,535 5000

Yes

MAXRBLK

RID pool size

0, 16K–1,000,000K calculated

Yes

MAXRTU

Read tape units

1–99 2

Yes

MAX_ST_PROC

Maximum number of stored procedures

0–99,999 2,000

Yes

MAXTYPE1

Maximum Type 1 inactive

0–MAX REMOTE CON

–Yes

MCCSID

EBCDIC coded character set (mixed byte)

0–65,533

MEMBNAME

Member name

1–8 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

0–50,000 1,000

Yes

NUMLKUS

Locks per user

0–100,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

40K–400MB 400K

No

PADIX

Pad index by default

YES, NO

Yes

PADNTSTR

Pad null-terminated strings

YES, NO

Yes

PARAMDEG

Degree of parallelism

0–no upper limit

–Yes

PARTKEYU

Allow partitioning keys to be updated

YES, NO, or same

Yes

PCLOSEN

Read-only switch checkpoints

1–32,767 5

Yes

PCLOSET

Read-only switch time

1–32,767 10

Yes

POOLINAC

Pool thread timeout

0–9,999 120

Yes

PRIQTY

Primary quantity

Blank, 1–9,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

0–999 5

Yes

RECALL

Recall database

YES, NO

No

RECALLD

Recall delay

0–32,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

0–254

–Yes

RETVLCFK

Varchar from index

NO, YES

Yes

RGFCOLID

Registration owner

1–8 characters DSNRGCOL

No

RGFDBNAM

Registration database

1–8 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

1–17 characters DSN_REGISTER_OBJT

No

RGFNMPRT

APPL registration table

1–17 characters

DSN_REGISTER_APPL

No

RLF

RLF autostart

NO, YES

No

RLFAUTH

Resource Authid

SYSIBM, or authid

Yes

RLFERR

RLST access error

NOLIMIT, NORUN,1–50,000,000

Yes

RLFERRD

RLST access error

NOLIMIT, NORUN,1–50,000,000

Yes

RLFTBL

RLST name suffix

01, 2 alphanumeric characters

Yes

ROUTCDE

WTO route codes

1, 1–14 route codes

No

RRULOCK

U lock for RR/RS

NO, YES

Yes

SCCSID

EBCDIC coded character set (single byte)

0–65,533

SECQTY

Secondary quantity

Blank, CLIST calculated, 1–9,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

0–1,024 20

Yes

SJTABLES

Number of tables in star join

 

Yes

SMFACCT

SMF accounting

NO, YES(1), list (1–5,7,8), *

No

SMFSTAT

SMF statistics

YES (1,3,4), NO, list(1–5) , *

No

SMSDCFL

SMS data class for file table space

Blank, 1–8 characters

Yes

SMSDCIX

SMS data class for index table space

Blank, 1–8 characters

Yes

SPRMEDX

   

Yes

SPRMLTD

Size threshhold for compression

10

SQLDELI

SQL string delimiter

Default, ', "

SRTPOOL

Sort pool size

240K–64,000K

Yes

SSID

Subsystem name

DSN, SSID

STARJOIN

Enabling star join

Disable, enable, 1, 2–32,768

Yes

STATHIST

Collect historical statistics

SPACE, NONE, ALL, ACCESSPATH

Yes

STATSINT

Time to write RTS stats

1–1,440 minutes 30

Yes

STATROLL

Run stats aggregates partition-level statistics

YES, NO

Yes

STATIME

Statistics time

1–1,440 minutes 30

Yes

STDSQL

Standard SQL language

NO, YES

STORMXAB

Maximum abend count

0–225

–Yes

STORPROC

DB2 procedure name

1–8 characters ssnmSPAS

No

STORTIME

Timeout value

5–1,800 seconds 180

Yes

SUPERRS

Suppress logrec recording during soft errors

YES, NO

Yes

SVOLARC

Single volume

YES, NO

Yes

SYNCVAL

Statistics sync

NO, 0–59

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, 1–65,524 120

Yes

TIME

Time format

ISO, JIS, USA, EUR, LOCAL

TIMELEN

Local time length

0, 8–254

TRACLOC

Size of local trace table

16 (4K bytes)

 

TRACSTR

Trace autostart

NO, YES (1–3), list (1–9)

No

TRACTBL

Trace size

4–396K 64K

No

TRKRSITE

Remote tracker site usage

NO, YES

No

TSQTY

Define allocation for table space

0–4,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

0–255

Yes

URLGWTH

UR log write check

0–1,000K

Yes

USCCSID

Unicode CCSID (single byte)

1,208

UTIMOUT

Utility timeout

1–254

Yes

VOLTDEVT

Temporary unit name

SYSDA, valid name

Yes

WLMENV

WLM environment

Valid name, 1–18 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
  • + Share This
  • 🔖 Save To Your Account