Mainframe Blog

DSNZPARMs in Db2 12

10 minute read
Stephen Watts

(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)

Parameter Description Acceptable values (defaults appear in bold) Online
ABEXP EXPLAIN processing YES, NO Yes
ABIND Auto BIND YES, NO Yes
ACCEL Acceleration Startup NO, AUTO, COMMAND No
ACCELMODEL Enable modelling NO, YES Yes
ACCESS_CNTL_MODULE DB2 access control routine load module 1-8 Char (install), DSNX@XAC (migration) No
ACCUMACC DDF/RRSAF accumulation data NO, 2-65535 Yes
ACCUMUID Aggregation fields 0-10 Yes
ADMTPROC JCL procedure used to start administrative scheduler 1-8, ssnADMT No
AEXITLIM Authorization exit limit 0-32676, 10 Yes
AGCCSID ASCII coded character set (mixed) 0-65533 __
ALTERNATE_CP Alternate copy pool Blank, name of copy pool Yes
AMCCSID ASCII coded character set (mixed) 0-65533 __
APPENSCH Application encoding ASCII, EBCDIC, UNICODE, ccsid __
APPLCOMPAT Application compatibility V10R1, V11R1 Yes
ARCPFX1 Copy 1 prefix 1-34 char Yes
ARCPFX2 Copy 2 prefix 1-34 char Yes
ARCRETN Retention period 0-9999 Yes
ARCWRTC WTOR route code 1-16, 1,3,4 Yes
ARCWOTR Write to operator NO, YES Yes
ARC2FRST Read copy 2 archive NO, YES Yes
ASCCID ASCII coded character set (single-byte) 0-65533 __
AUDITST Audit trace NO, YES, list, * No
AUTH Use protection YES, NO No
AUTHCACH Plan auth cache 0-4096, 1024 Yes
AUTH_

COMPATIBILITY

Release Authorization rules Blank, SELECT_FOR_UNLOAD Yes
AUTHEXIT_

CACHEREFRESH

Authorization cache refresh ALL, NONE Yes
AUTHEXIT_

CHECK

ID use for authorization checks PRIMARY, DB2 Yes
BACKODUR Backout duration 0-255, 5 No
BIF_

COMPATIBILITY

Built-in function format CURRENT

V9_DECIMAL_VARCHAR

Yes
BINDNV Bind new package BINDADD, BIND Yes
BLKSIZE Block size 8192-28672 Yes
BMPTOUT IMS BMP timeout 1-254; 4 Yes
CACHEDYN Cache dynamic SQL NO, YES Yes
CACHEDYN_

STABLILIZATION

Allow dynamic statement stabilization BOTH, CAPTURE, LOAD, NONE Yes
CACHEPAC Package authorization cache 0-2MB; 5M No
CACHERAC Routine authorization cache 0-2MB; 5M No
CATALOG Catalog alias 1-8 char; DSNCAT Yes
CATDDACL SMS class for catalog and directory table spaces Valid SMS class, blank Yes
CATDMGCL SMS class for catalog and directory table spaces Valid SMS class, blank Yes
CATDSTCL SMS class for catalog and directory table spaces Valid SMS class, blank Yes
CATXDACL SMS class for catalog and directory indexes Valid SMS class, blank Yes
CATXMGCL SMS class for catalog and directory indexes Valid SMS class, blank Yes
CATXSTCL SMS class for catalog and directory indexes Valid SMS class, blank Yes
CDSSRDEF Current degree 1, Any Yes
CHECK_

FASTREPLICATION

Type of replication used to copy objects PREFERRED REQUIRED Yes
CHECK_

SETCHKP

CHECK DATA and CHECK LOB place inconsistent objects in CHECK PENDING YES, NO Yes
CHGDC DROP support 1,2,3 Yes
CHKFREQ Number of log records created between checkpoints 1000-16000000(CHKTYPE=LOGRECS), NOTUSED, (CHKTYPE=MINUTES), 5, 99999999 (CHKTYPE=BOTH) Yes
CHKLOGR Number of log records created between checkpoints 1000-16000000(CHKTYPE=LOGRECS), NOTUSED, (CHKTYPE=MINUTES), 99999999(CHKTYPE=BOTH) Yes
CHKMINS Number of minutes between log checkpoints LOGRECS, MINUTES, BOTH Yes
CMTSTAT DDF threads ACTIVE, INACTIVE No
COMPACT Compact data NO, YES Yes
COMPRESS_

DIRLOB

Compress DB2 Directory LOB NO, YES Yes
COMPRESS_SPT01 Compress SPT01 directory table space YES, NO Yes
CONDBAT Max remote connected 0-25000; 64 Yes
COPY_

FASTREPLICATION

Copy fast replication PREFERRED, REQUIRED, NONE Yes
CTHREAD Max users 1-2000; 70 Yes
DBACRVW DBADM can create view for other authid YES, NO Yes
DATE Date format ISO, USE, EUR, JIS, LOCAL __
DATELEN Local date format 0, 10-254 __
DB2SUPLD Serviceability parameter __ __
DDF DDF startup option NO, AUTO, COMMAND No
DDF_

COMPATIBILITY

DDF connection characteristics Blank, DISABLE_IMPACT_JV, IDNTFY_V12_PRIOR_VER, IGNORE_TZ, SP_PARMS_NJV Yes
DDL_

MATERIALIZATION

When DB2 materialization occurs 1(immediate), 2(pending) Yes
DDLTOX DDL Timeout 1-254 Yes
DEALLCT Deallocate period 0-1439 min, 0-59 sec, NOLIMIT Yes
DECARTH Decimal arithmetic DEC15, DEC31, 15, 31 __
DECDIV3 Minimum divide scale NO, YES No
DEF_DECFLOAT_

ROUND_MODE

Decfloat rounding mode ROUND_CEILING, ROUND_DOWN, ROUND_FLOOR, ROUND_HALF_DOWN, ROUND_HALF_EVEN, ROUND_HALF_UP, ROUND_HALF_EVEN __
DEFAULT_INSERT_

ALGORITHM

Default insert algorithm 1(basic), 2(fast) Yes
DEFLANG Language default ASM, C, CPP, COBOL, COB2, IBMCOB, FORTRAN, PL1 __
DEFLTID Unknown authid IBMUSER, authid No
DELIM String delimiter DEFAULT, “,’ __
DEL_

CFSTRUCTS_

ON_RESTART

Delete coupling facility structures on restart NO, YES No
DESCSTAT Describe for static NO, YES Yes
DISABLE_EDMRTS Disable EDM RTS NO, YES Yes
DLDFREQ Level ID update frequency 0-32767, ON Yes
DLITOUT DL/I batch timeout 1-254, 6 Yes
DPSEGSZ Default partition Segsize 0,4,12,..64(multiples of 4), 32 Yes
DSHARE Data sharing Yes, No, blank No
DSMAX Data set maximum 1-32767; 20000 Yes
DSQLDELI Dist SQL string delimiter ‘,” __
DSSTIME Data set stats time 1-1440; 5 Yes
DSCVI Vary DS control interval YES, NO Yes
DYNRULS Use for dynamic rules YES, NO __
EDM_

SKELETON_POOL

Minimum size of EDM skeleton pool in KB 5120-2097152, 10240K Yes
EDMDBDC EDM BDC cache 5000K-2097152K Yes
EDMSTMTC EDM statement cache size 0-1048576K; 113386K Yes
EDPROP DROP support 1, 2, 3 Yes
EN_PJSJ Enable index ANDing ON, OFF Yes
ENSCHEME Default encoding scheme EBCDIC, ASCII __
EVALUNC Predicate evaluation with UR and RS YES, NO Yes
EXTRAREQ Extra blocks requestor 0-100 Yes
EXTRASRV Extra blocks server 0-100 Yes
EXTSEC Extended security NO, YES Yes
FCCOPYDDN Default for FCCOPYDDN of FLASHCOPY clause for utilities Valid DB2 utilities template, HLQ.&DB.&SN.N&DS.D&JU.T&TL Yes
FLASHCOPY Default setting for FLASHCOPY for utilities NO, YES, CONSISTENT Yes
FLASHCOPY_COPY FLASHCOPY clause used by default for COPY utility NO, YES Yes
FLASHCOPY_LOAD FLASHCOPY clause used by default for LOAD utility NO, YES Yes
FLASHCOPY_PPRC FLASHCOPY behavior with PPRC NO, YES Yes
FLASHCOPY_

REBUILD_

INDEX

FLASHCOPY clause used by default for REBUILD INDEX utility NO, YES Yes
FLASHCOPY_

REORG_

INDEX

FLASHCOPY clause used by default for REORG INDEX utility NO, YES Yes
FLASHCOPY_

REORG_TS

FLASHCOPY clause used by default for REORG TABLESPACE utility NO, YES Yes
GCCSID EBCDIC coded character set (graphic byte) 0-65533 __
GET_ACCEL_

ARCHIVE

Get Accel Archive NO, YES Yes
GRPNAME Group name 1-8 char, DSNCAT No
HONOR_

KEEPDICTIONARY

Honor KEEPDICTIONARY on LOAD or REORG YES, NO Yes
IDAUTH_MODULE DB2 connection authorization exit routine 1-8 char, DSN3@ATH No
IDBACK Max batch connect 1-2000; 40 Yes
IDFORE Max TSO connect 1-2000, 40 Yes
IDTHTOIN Idle thread timeout 0-9999 Yes
IDXBPOOL Default buffer pool for user indexes BP0-BPx Yes
IGNSORTN Ignore SORTNUM in utilities YES, NO Yes
IMMEDWRI Immediate write NO, YES, PH1 Yes
IMPDSDEF Define datasets YES, NO Yes
IMPDSSIZE Max DSSIZE for implicit 1,2,4,8,16,32,64 Yes
IMPLICIT_

TIMEZONE

Default value for time zone CURRENT, SESSION, 12:59 to +14:00 __
IMPTKMOD Trackmod for implicit YES, NO Yes
IMPTSMP Use data compression YES, NO Yes
INDEX_CLEANUP_

THREADS

Index Cleanup Threads 0-128, 10 Yes
INDEX_MEMORY_

CONTROL

Index memory control AUTO, DISABLE, 10-200000 Yes
INDEX_IO_

PARALLELISM

I/O parallelism enable for index insertion I/O YES, NO Yes
INLISTP IN list elements 1-5000; 50 Yes
IRLMAUT Auto start YES, NO No
IRLMPRC Proc name IRLMPROC, IRLM procedure name No
IRLMRWT Resource timeout 1-3600; 30 No
IRLMSID Subsystem name IRLM, IRLM name No
IRLMSWT Time to autostart 1-3600; 120 Yes
IX_TB_PART_

CONV_EXCLUDE

Exclude trailing columns NO, YES Yes
IXQTY Indexspace default size 0-4194304 Yes
LBACKOUT Postpone backward log processing AUTO, YES, NO No
LC_CTYPE Locale LC_CTYPE Valid locale, 0-50 char __
LIKE_BLANK_

INSIGNIFICANT

Blank significance in LIKE NO, YES
LOB_INLINE_

LENGTH

Default length for inline LOBs 0-32680 Yes
LRDRTHLD Long-running reader threshold 0-1439 minutes, 10 Yes
MAINTYPE Current maintenance types for MQTs NONE, SYSTEM, USER, ALL Yes
MATERIALIZE_

NODET_SQLTUDF

Materialize non deterministic table func NO, YES Yes
MAXSORT_IN_

MEMORY

Max in-memory sort size 1000 to value of SRTPOOL Yes
MAX_CONCURRENT_

PKG_OPS

Max automatic bind requests processed simultaneously 10 Yes
MAXARCH Recording max 10-1000 No
MAXCONQN Max queued connections OFF, ON, 1-19999 Yes
MAXCONQW Max queued wait time OFF, ON, 5-3600 Yes
MAXDBAT Max remote active 0-1999; 64 Yes
MAX_NUM_CUR Max open cursors 0-99999; 500 Yes
MAX_ST_PROC Max number of stored procedures 0-99999; 2000 Yes
MAXKEEPD Max kept dynamic statements 0-65535; 5000 Yes
MAXOFILR Maximum number of data sets concurrently open for LOB file references 0 to value of MAX USERS, 100 Yes
MAXRBLK RID pool size 0, 16K-1000000K; 400MB Yes
MAXRTU Read tape units 1-99; 2 Yes
MAXTEMPS Max temp/stage agent 0-214748364 Yes
MAXTEMPS_RID Max temp storage in work files in RIDs NONE, NOLIMIT, or 1 to 329166 Yes
MAXTYPE1 Max type 1 inactive 0-MAX REMOTE CON value Yes
MCCSID EBCDIC coded character set (mixed byte) 0-65533 __
MEMBNAME Member name 1-8 char; DSN1 No
MGEXTSZ Optimize extent sizing YES, NO Yes
MINSTOR Thread management YES, NO Yes
MIXED Mixed data NO, YES __
MON Monitor trace NO, YES No
MXDTCACH Maximum size of memory for data caching 0-512, 20 Yes
NPGTHRSH Use of index after table growth 0, -1, n Yes
NUMLKTS Locks per table space 0-50000; 2000 Yes
NUMLKUS Locks per user 0-100000; 10000 Yes
OBJECT_CREATE_

FORMAT

Objects created with basic or extended log BASIC(migration)

EXTENDED(install)

Yes
OPT1ROWBLOCK

SORT

Block sort operations for OPT FOR 1 ROW ENABLE, DISABLE YES
OPTHINTS Optimization hints NO, YES Yes
OTC_LICENSE Accept terms of one-time change license YES, NONE No
OUTBUFF Output buffer 40k-400MB; 400K No
PADIX Pad index by default YES, NO Yes
PADNTSTR Pad null-terminated strings YES, NO Yes
PAGESET_

PAGENUM

Page set page numbering ABSOLUTE, RELATIVE Yes
PARA_EFF Parallelism efficiency 0-100, 50 Yes
PARAMDEG Degree of parallelism 0-no upper limit Yes
PARAMDEG_DPSI Deg of parallelism for DPSI 0-254, DISABLE Yes
PARAMDEG_UTIL Deg of parallelism for utilities 0-32767 Yes
PCLOSEN RO switch checkpoints 1-32767; 5 Yes
PCTFREE_UPD Percent free for update AUTO, 0-99 Yes
PCLOSET RO switch time 1-32767; 10 Yes
PEER_RECOVERY Peer recovery NONE, RECOVER, ASSIST, BOTH Yes
PKGREL_COMMIT Package Release Commit YES, NO Yes
PLANMGMT Default plan management policy OFF, ON, BASIC, EXTENDED Yes
PLANMGMT_SCOPE Default plan management scope ALL, STATIC, DYNAMIC Yes
POOLINAC Pool thread timeout 0-9999; 120 Yes
PRIQTY Primary quantity Blank, 1-9999999 Yes
PREVENT_

ALTERTB_

LIMITKEY

Prevent Alter Limitkey NO, YES Yes
PREVENT_NEW_

IXCTRL_PART

Prevent Index Part Create NO, YES Yes
PROFILE_

AUTOSTART

Profile autostart NO, YES No
PROTECT Archive logs protected with RACF NO, YES Yes
PTASKROL Include accounting traces for parallel tasks YES, NO Yes
QUERY_ACCEL_

OPTIONS

Acceleration options NONE, YES Yes
QUERY_

ACCELERATION

Default for CURRENT QUERY ACCELERATION special register NONE, ENABLE, ENABLE_WITHFAILBACK Yes
QUIESCE Quiesce period 0-999; 5 Yes
RANDOMATT DB2 member can be used for randomized group attach YES, NO Yes
REALSTORAGE_

MANAGEMENT

Whether DB2 manages real storage ON, OFF, AUTO Yes
REC_FAST

REPLICATION

Use FLASHCOPY with recover NONE, PREFERRED, REQUIRED Yes
RECALL Recall database YES, NO No
RECALLD Recall delay 0-32767; 120 Yes
REFSHAGE Current refresh age 0, ANY Yes
REMOTE_COPY_

SW_ACCEL

Remote copy sw accel DISABLE, ENABLE Yes
RENAMETABLE Rename table DISALLOW_DEP_VIEW_SQLTUDF, ALLOW_DEP_VIEW_SQLTUDF Yes
REORG_DROP_

PBG_PARTS

Remove trailing empty partitions during REORG DISABLE, ENABLE Yes
REORG_LIST_

PROCESSING

Default for PARALLEL option on REORG PARALLEL, SERIAL Yes
REORG_MAPPING_

DATABASE

Default database for mapping table Blank, 8 byte character string Yes
REORG_PART_

SORT_NPI

Default for sorting nonpartitioned index during REORG AUTO, NO, YES Yes
RESTART Restart or defer RESTART, DEFER __
RESTORE_

RECOVER_

FROMDUMP

Recovery/restore YES, NO Yes
RESTORE_

TAPEUNITS

Maximum tape units NOLIMIT, 1-255 Yes
RESTRICT_ALT_

COLD_FOR_DCC

Restrictions during ALTER TABLE ALTER COLUMN if DATA CAPTURE CHANGES is used NO, YES Yes
RESYNC Resync interval 1-99; 2 Yes
RETLWAIT Retained lock timeout 0-254 Yes
RETRY_STOPPED_

OBJECT

Retry stopped object NO, YES No
REVOKE_DEP_

PRIVILEGES

Revoked privileges are also revoked from dependents NO, YES, SQLSTMT Yes
RGFCOLID Registration owner 1-8 char, DSNRGCOL No
RGFDBNAM Registration database 1-8 char, DSNRGFDB No
RGFDEDPL Control all applications NO, YES No
RGFDEFLT Unregistered DDL default APPL, ACCEPT, REJECT No
RGFESCP ART/ORT escape character Non-alphanumeric char No
RGFFULLQ Require full names YES, NO No
RGFINSTL Install DD control support NO, YES No
RGFNMORT OBJT registration table 1-17char; DSN_REGISTER_OBJT No
RGFNMPRT APPL registration table 1-17char, DSN_REGISTER_APPL No
RLF RLF auto start NO, YES No
RLFENABLE RLF scope DYNAMIC, STATIC, ALL No
RLFAUTH Resource authid SYSIBM, authid Yes
RLFERR RLST access error NOLIMIT, NORUN,

1-500000

Yes
RLFERRD Remote dynamic SQL NOLIMIT, NORUN,

1-500000

Yes
RLFERRSTC Static SQL NOLIMIT, NORUN,

1-500000

Yes
RLFERRDSTC Remote static SQL NOLIMIT, NORUN,

1-500000

Yes
RLFTBL RLST name suffix 01, 2 alphanumeric char 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-65533 __
SECADM1 Security administrator SECADM, If type is AUTHID then 1-8 characters, if type is ROLE then SQL identifier Yes
SECADM1_TYPE Type of security administrator AUTHID, ROLE Yes
SECADM1_INPUT_

STYLE

Setting passed as hex string or character CHAR, HEX Yes
SECADM2 Second security administrator SECADM, if type is AUTHID then-1-8 characters, if type is ROLE then SQL identifier Yes
SECADM2_INPUT_

STYLE

Setting passed as hex string or character CHAR, HEX Yes
SECADM2_TYPE Type of security administrator AUTHID, ROLE Yes
SECQTY Secondary quantity Blank (clist calculated),

1-9999999

Yes
SEPARATE_

SECURITY

Separate DB2 security administration from system administration NO, YES Yes
SIGNON_MODULE No
SIMULATED_CPU_

COUNT

Number of CPUs being simulated OFF, 1-255 Yes
SIMULATED_CPU_

SPEED

Microseconds of execution time for CPU being simulated OFF, 1-2147483647 Yes
SITETYP Site type LOCALSITE, RECOVERYSITE No
SJTABLES Number of tables in star join 1-255; 10 Yes
SKIPUNCI Skip uncommitted inserts YES, NO Yes
SMF89 Measured usage pricing YES, NO Yes
SMFACCT SMF accounting NO, YES(1), list(1-5,7,8),* No
SMFCOMP Compression SMF OFF, ON Yes
SMFSTAT SMF statistics YES(1,3,4), NO, list(1-5),* No
SPT101_INLINE_

LENGTH

Max inline length of LOB in SPT101 NOINLINE,1-32138 Yes
SQLDELI SQL string delimiter Default, ‘, “ __
SQLLVEL Precompiler SQL level V10R1, V11R1, function-level Yes
SRTPOOL Sort pool size 240K-64000K; 10000K Yes
SSID Subsystem name DSN, SSID __
STARJOIN Enabling star join Disable, enable, 1, 2-32768 Yes
STATFDBK_

PROFILE

Statistics profile feedback YES, NO Yes
STATFDBK_SCOPE Statistics feedback ALL, DYNAMIC, NONE, STATIC Yes
STATHIST Collect historical statistics SPACE, NONE, ALL, ACCESSPATH Yes
STATSINT Time to write RTS stats 1-1440 min; 30 Yes
STATROLL Runstats aggregates partition-level statistics YES, NO Yes
STATIME Statistics time 1-1440 min; 1 Yes
STDSQL Standard SQL language NO, YES __
STORMXAB Max abend count 0-225 Yes
STORTIME Timeout value 5-1800 sec; 180 Yes
SUBQ_MIDX Multiple index access ENABLE, DISABLE Yes
SUPERRS Suppress Logrec recording during soft errors YES, NO Yes
SUPPRESS_HNT_

SQLCODE_DYN

Suppress SQLCODE for hints NO, STMT, ALL Yes
SVOLARC Single volume YES, NO Yes
SYNCVAL Statistics sync NO, 0-59 Yes
SYSADM System admin 1 SYSADM, authid Yes
SYSADM2 System admin 2 SYSADM, authid Yes
SYSOPR1 System operator 1 SYSOPR, authid Yes
SYSOPR2 System operator 2 SYSOPR, authid Yes
SYSTEM_LEVEL_

BACKUPS

System-level backups YES, NO Yes
TBSBP8K Default 8K BP for user data Any 8K buffer pool, BP8K0 Yes
TBSBP16K Default 16K BP for user data Any 16K buffer pool, BP16K0 Yes
TSBBP32K Default 32K BP for user data Any 32K buffer pool BP32K0 Yes
TBSBPOOL Default buffer pool for user data BP0-BPx Yes
TBSBPXML Default buffer pool for XML table spaces Any 16K bufferpool, BP16K Yes
TCPALVER TCP/IP already verified NO, YES Yes
TCPKPALV TCP/IP keep alive ENABLE, DISABLE, 1-65524 Yes
TEMPLATE_TIME Template time UTC, LOCAL Yes
TIME Time format ISO, JIS, USA, EUR, LOCAL __
TIMELEN Local time length 0, 8-254 __
TRACSTR Trace auto start NO, YES (1-3), list (1-9) No
TRACTBL Trace size 4K-396K; 64K No
TRKRSITE Remote tracker site usage NO, YES No
TSQTY Default allocation for table space 0-4194304 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 No
UGCCSID Unicode CCSID (graphic) 1208 __
UIFCIDS Unicode IFCIDS YES, NO Yes
UMCCSID Unicode CCSID (mixed) 1208 __
UNION_

COLTNAME_7

Use Version 7 behavior for union results YES, NO Yes
UNIT Device type 1 TAPE, any device Yes
UNIT2 Device type 2 Device or unit name Yes
URCHKTH UR check frequency 0-255, 5 Yes
URLGWTH UR log write check 0K-1000K Yes
USCCID Unicode CCSID

(single-byte)

1208 __
UTIL_DBBSG DB backup stg grp Blank, SMS-stogroup-name Yes
UTIL_LGBSG Log backup stg grp Blank, SMS-stopgroup-name Yes
UTIL_HSM_

MSGDS_HLQ

HSM message DS HLQ Blank, data-set-qualifier Yes
UTIL_TEMP_

STORCLAS

Storage class name for shadow data sets Blank, valid SMS management class name Yes
UTILS_DUMP_

CLASS_NAME

Dump class name Blank, valid DFSMS dump class name Yes
UTILITY_OBJECT_

CONVERSION

Utility object conversion BASIC, EXTENDED, NOBASIC,

NONE

Yes
UTIMOUT Utility timeout 1-254; 6 Yes
UTSORTAL DB2 uses RTS to determine sort work data set sizes YES, NO Yes
VOLTDEVT Temporary unit name SYSDA, valid name Yes
WFDBSEP Declared temporary tables will use work files with non-zero SECQTY YES, NO No
WFSTGUSE_

AGENT_

THRESHOLD

Agent level threshold in work file database 0-100 Yes
WFSTGUSE_SYST

EM_THRESHOLD

System level threshold in work file database 0-100 Yes
WLMENV WLM environment Valid name (1-18 char) Yes
XLKUPDT X lock for searched U/D YES, NO Yes
XML_RANDOMIZE_

DOCID

Generate XML DOCID values randomly NO, YES Yes
XMLVALA Upper limit for storage for per user for XML values 1-2097152, 204,800 Yes
XMLVALS Upper limit for system storage for XML values 1-51200, 10240 Yes
ZOSMETRICS Enables DB2 to gather z/OS metrics YES, NO No

Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at [email protected]. Db2 is a registered trademark of the IBM Corporation.

Order now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC. This collateral helps Db2 for z/OS users with daily activities in administering and programming for Db2 on z/OS.


These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing [email protected].

Business, Faster than Humanly Possible

BMC empowers 86% of the Forbes Global 50 to accelerate business value faster than humanly possible. Our industry-leading portfolio unlocks human and machine potential to drive business growth, innovation, and sustainable success. BMC does this in a simple and optimized way by connecting people, systems, and data that power the world’s largest organizations so they can seize a competitive advantage.
Learn more about BMC ›

About the author

Stephen Watts

Stephen Watts (Birmingham, AL) contributes to a variety of publications including, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.