DSNZPARMs in Db2 12
(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 blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.