Directory of subsystem parameters, panel fields, and application default values

Subsystem, installation panel fields, and application default values are settings that apply to an entire Db2 subsystem. Most but not all subsystem parameters correspond to installation panel fields. Also, some panel fields do not correspond to a subsystem parameter.

The following table lists subsystem parameters and macro names, installation panel fields and panel names, and whether each parameter can be updated online. Yes in the Update online column means that the parameter can be updated online.

Table 1. Directory of subsystem parameters and application default values
Parameter name	Field name	Macro	Panel	Update online	DS²	DSNTID`xx` entry or z/OSMF variable ¹
ABEXP	EXPLAIN PROCESSING	DSN6SPRM	DSNTIPO	Yes	M	ABEXP
ABIND	AUTO BIND	DSN6SPRM	DSNTIPO	Yes	M	ABIND
ACCEL	ACCELERATION STARTUP	DSN6SPRM	DSNTIP82		M	ACCEL
ACCELMODEL	—	DSN6SPRM	—	Yes	M	ACCELMODEL
ACCESS_CNTL_MODULE	ACCESS CONTROL	DSN6SYSP	DSNTIPO3		G	ACCTLMOD
ACCUMACC	DDF/RRSAF ACCUM	DSN6SYSP	DSNTIPN	Yes	M	ACCUMAC
ACCUMUID	AGGREGATION FIELDS	DSN6SYSP	DSNTIPN	Yes	M	ACCUMUID
ADMTPROC	ADMIN SCHEDULER	DSN6SPRM	DSNTIPX		M	ADMTPROC
AEXITLIM	AUTH EXIT LIMIT	DSN6SPRM	DSNTIPP	Yes	M	AEXITLIM
AGCCSID	ASCII CCSID	DSNHDECP	DSNTIPF		G	AGCCSID
ALL	START NAMES	DSN6SPRM	DSNTIPS		—	—
ALLOW_UPD_DEL_INS_WITH_UR	—	DSN6SPRM	—	Yes	G	AUDIWU
ALTERNATE_CP	ALTERNATE COPY POOL	DSN6SPRM	DSNTIP62	Yes	G	BSACP
AMCCSID	ASCII CCSID	DSNHDECP	DSNTIPF		G	AMCCSID
APPENSCH	APPLICATION ENCODING	DSNHDECP	DSNTIPF		G	APPENSCH
APPLCOMPAT	APPL COMPAT LEVEL	DSN6SPRM	DSNTIP00	Yes	G	APPLCOMPAT
ARCPFX1	Archive logs: COPY 1 PREFIX	DSN6ARVP	DSNTIPH	Yes	U	ARCHPRE1
ARCPFX2	Archive logs: COPY 2 PREFIX	DSN6ARVP	DSNTIPH	Yes	U	ARCHPRE2
ARCRETN	RETENTION PERIOD	DSN6ARVP	DSNTIPA	Yes	M	ARCRETN
ARCWRTC	WTOR ROUTE CODE	DSN6ARVP	DSNTIPA	Yes	M	ARCHWRTC
ARCWTOR	WRITE TO OPER	DSN6ARVP	DSNTIPA	Yes	M	ARCHWTOR
ARC2FRST	READ COPY2 ARCHIVE	DSN6LOGP	DSNTIPO	Yes	M	ARC2FRST
ASCCSID	ASCII CCSID	DSNHDECP	DSNTIPF		G	ASCCSIDE
AUDITST	AUDIT TRACE	DSN6SYSP	DSNTIPN	No ³	M	AUDIT
AUTH	USE PROTECTION	DSN6SPRM	DSNTIPP	No ³	M	PROTAUTH
AUTHCACH	PLAN AUTH CACHE	DSN6SPRM	DSNTIPP	Yes ³	M	AUTHCACH
AUTHEXIT_CACHEREFRESH	AUTH EXIT CACHE REFR	DSN6SPRM	DSNTIPP	No ³	G	AECR
AUTH_COMPATIBILITY	—	DSN6SPRM	—	Yes	M	AUTCMPAT
AUTHEXIT_CHECK	AUTH EXIT CHECK	DSN6SPRM	DSNTIPP	No ³	G	RACK
BACKODUR	BACKOUT DURATION	DSN6SYSP	DSNTIPL1		M	BACKODUR
BIF_COMPATIBILITY	BIF COMPATIBILITY	DSN6SPRM	DSNTIPX	Yes	—	BIFCP
BINDNV	BIND NEW PACKAGE	DSN6SPRM	DSNTIPP1	Yes ³	M	BINDNV
BLKSIZE	BLOCK SIZE	DSN6ARVP	DSNTIPA	Yes	M	ARCHSIZE
BMPTOUT	IMS BMP TIMEOUT	DSN6SPRM	DSNTIPI	Yes	M	BMPTOUT
CACHEDYN	CACHE DYNAMIC SQL	DSN6SPRM	DSNTIP8	Yes	M	CACHEDUM
CACHEDYN_STABILIZATION	CACHE DYN STABILITY	DSN6SPRM	DSNTIP8	Yes	G	CDST
CATALOG	CATALOG ALIAS	DSN6SPRM	DSNTIPA2		G	VCATALOG
CATDDACL	DIRECTORY AND CATALOG DATA	DSN6SPRM	DSNTIPA2	Yes	M	CATDDACL
CATDMGCL	DIRECTORY AND CATALOG DATA	DSN6SPRM	DSNTIPA2	Yes	M	CATDMGCL
CATDSTCL	DIRECTORY AND CATALOG DATA	DSN6SPRM	DSNTIPA2	Yes	M	CATDSTCL
CATXDACL	DIRECTORY AND CATALOG INDEXES	DSN6SPRM	DSNTIPA2	Yes	M	CATXDACL
CATXMGCL	DIRECTORY AND CATALOG INDEXES	DSN6SPRM	DSNTIPA2	Yes	M	CATXMGCL
CATXSTCL	DIRECTORY AND CATALOG INDEXES	DSN6SPRM	DSNTIPA2	Yes	M	CATXSTCL
CDDS_MODE	—	DSN6LOGP	—		G	CDDSMOD
CDDS_PREFIX	—	DSN6LOGP	—		G	CDDSPFX
CDSSRDEF	CURRENT DEGREE	DSN6SPRM	DSNTIP81 DSNTIP8	Yes	M	CDSSRDEF
CHECK_FASTREPLICATION	FAST REPLICATION	DSN6SPRM	—	Yes	M	CHKFASRP
CHKFREQ	CHECKPOINT FREQ	DSN6SYSP	DSNTIPL1	Yes	M	CHKFREQ
CHKLOGR	RECORDS/CHECKPOINT	DSN6SYSP	DSNTIPL1	Yes	M	CHKLOGR
CHKMINS	MINUTES/CHECKPOINT	DSN6SYSP	DSNTIPL1	Yes	M	CKPTTIME
CHKTYPE	CHECKPOINT TYPE	DSN6SYSP	DSNTIPL1	Yes	M	CHKTYPE
CMTSTAT	DDF THREADS	DSN6FAC			M	CMTSTAT
COMCRIT	—	DSN6SPRM	—	Yes	M	COMCRIT
COMPACT	COMPACT DATA	DSN6ARVP	DSNTIPA	Yes	M	ARCHCOMP
COMPRESS_DIRLOB	COMPRESS DB2 DIR LOBS	DSN6SPRM	DSNTIPA2	Yes	G	CDRL
CONDBAT	MAX REMOTE CONNECTED	DSN6SYSP	DSTIPE	Yes	M	CONDBAT
COPY_FASTREPLICATION	COPY FAST REPLICATION	DSN6SPRM	DSNTIP61	Yes	R	CYFR
CTHREAD	MAX USERS	DSN6SYSP	DSNTIPE	Yes	M	NUMCONCR
DBACRVW	DBADM CREATE AUTH	DSN6SPRM	DSNITPP1	Yes ³	G	DBACRVW
DATE	DATE FORMAT	DSNHDECP	DSNTIP4		G	DEFDATE
DATELEN	LOCAL DATE LENGTH	DSNHDECP	DSNITP4		G	DEFDATEL
DB2SUPLD	—	DSNHDECP	—		—	DB2SUPLD
DDF	DDF STARTUP OPTION	DSN6FAC	DSNTIPR		M	DDSTART
DDF_COMPATIBILITY	—	DSN6FAC	—	Yes	M	DDFCMPAT
DDL_MATERIALIZATION	DDL MATERIALIZATION	DSN6SPRM	DSNTIP71	Yes	G	DDLM
DDLTOX	DATA DEF TIMEOUT	DSN6SPRM	DSNTIPE1	Yes	M	DDLTOX
DEALLCT	DEALLOC PERIOD	DSN6LOGP	DSNTIPA	Yes	M	ARCHDEAP
DECARTH	DECIMAL ARITHMETIC	DSNHDECP	DSNTIP4		G	DECARTH
DECDIV3	MINIMUM DIVIDE SCALE	DSN6SPRM	DSNTIP4		G	DECDIV3
DECIMAL	DECIMAL POINT IS	DSNHDECP	DSNTIPF		G	DECPOINT
DEF_DECFLOAT_ROUND_MODE	DECFLOAT ROUNDING MODE	DSNHDECP	DSNTIPF		G	DEFDFPRM
DEFAULT_INSERT_ALGORITHM	DEFAULT INSERT ALGORITHM	DSN6SPRM	DSNTIP71	Yes	G	DINA
DEFLANG	LANGUAGE DEFAULT	DSNHDECP	DSNTIPF		G	DEFLANG
DEFLTID	UNKNOWN AUTHID	DSN6SPRM	DSNTIPP1		M	PROTUNKN
DEL_CFSTRUCTS_ON_RESTART	DEL CF STRUCTS	DSN6SYSP	DSNTIPK		G	DCFS
DELIM	STRING DELIMITER	DSNHDECP	DSNTIPF		G	DEFSTRNG
DESCSTAT	DESCRIBE FOR STATIC	DSN6SPRM	DSNTIP4	Yes	G	DECSTAT
DISABLE_EDMRTS	DISABLE EDM RTS	DSN6SPRM	DSNTIP8	Yes	G	DEDR
DISALLOW_SEL_INTO_UNION	—	DSN6SPRM	—	Yes	G	—
DISALLOW_SSARAUTH	—	DSN6SPRM	—	Yes ³	M	DSSAR
DLDFREQ	LEVELID UPDATE FREQ	DSN6SYSP	DSNTIPL1	Yes	M	DLDFREQ
DLITOUT	DL/I BATCH TIMEOUT	DSN6SPRM	DSNTIPI	Yes	M	DLITOUT
DPSEGSZ	DEFAULT PARTITION SEGSIZE	DSN6SYSP	DSNTIP71	Yes	G	DPSEGSZ
DSHARE	DATA SHARING	DSN6GRP	DSNTIPA1		—	DSHARE
DSMAX	DSMAX	DSN6SPRM	DSNTIPC	Yes	M	OPNDS
DSQLDELI	DIST SQL STR DELIMTR	DSNHDECP	DSNTIPF		G	DECPDSSD
DSSTIME	DATASET STATS TIME	DSN6SYSP	DSNTIPN	Yes	M	DSSTIME
DSVCI	VARY DS CONTROL INTERVAL	DSN6SYSP	DSNTIP7	Yes	—	DSVCI
DYNRULS	USE FOR DYNAMICRULES	DSNHDECP	DSNTIP4		G	DYNRULS
EDM_SKELETON_POOL	EDM SKELETON POOL SIZE	DSN6SPRM	DSNTIPC	Yes	M	EDMSKP
EDMDBDC	EDM DBD CACHE	DSN6SPRM	DSNTIPC	Yes	M	EDMDBDC
EDMSTMTC	EDM STATEMENT CACHE	DSN6SPRM	DSNTIPC	Yes	M	EDMSTMTC
EN_PJSJ	—	DSN6SPRM	—	Yes	M	ENPJSJ
ENCRYPTION_KEYLABEL	—	DSN6SPRM	—	Yes ^{3, 4}	G	ENKL
ENSCHEME	DEF ENCODING SCHEME	DSNHDECP	DSNTIPF		G	ENSHCEME
EVALUNC	EVALUATE UNCOMMITTED	DSN6SPRM	DSNTIP8	Yes	G	EVALUNC
EXTRAREQ	EXTRA BLOCKS REQ	DSN6SYSP	DSNTIP5	Yes	—	EXTRAREQ
EXTRASRV	EXTRA BLOCKS SRV	DSN6SYSP	DSNTIP5	Yes	—	EXTRSRV
EXTSEC	EXTENDED SECURITY	DSN6SYSP		Yes ³	G	EXTSEC
FCCOPYDDN	DEFAULT TEMPLATE	DSN6SPRM	DSNTIP61	Yes	M	FCCDTEMP
FLASHCOPY_COPY	COPY	DSN6SPRM	DSNTIP61	Yes	M	FCCP
FLASHCOPY_LOAD	LOAD	DSN6SPRM	DSNTIP61	Yes	M	FCLP
FLASHCOPY_PPRC	FLASHCOPY PPRC	DSN6SPRM	DSNTIP61	Yes	M	FCPPRC
FLASHCOPY_REBUILD_INDEX	REBUILD INDEX	DSN6SPRM	DSNTIP61	Yes	M	FCROT
FLASHCOPY_REORG_INDEX	REORG INDEX	DSN6SPRM	DSNTIP61	Yes	M	FCRBI
FLASHCOPY_REORG_TS	REORG TABLESPACE	DSN6SPRM	DSNTIP61	Yes	M	FCROI
FLASHCOPY_XRCP	FLASHCOPY XRCP	DSN6SPRM	DSNTIP61	Yes	M	—
FTB_NON_UNIQUE_INDEX	FTB NON UNIQUE INDEX		DSNTIP71	Yes	G	FTBUO
GCCSID	EBCDIC CCSID	DSNHDECP	DSNTIPF		G	GCCSID
GET_ACCEL_ARCHIVE	GET ACCEL ARCHIVE	DSN6SPRM	DSNTIP82	Yes	M	CGAA
GRPNAME	GROUP NAME	DSN6GRP	DSNTIPK		G	GRPNAME
HONOR_KEEPDICTIONARY	—	DSN6SPRM	—	Yes	—	HNRKPDIC
IDAUTH_MODULE	IDENTIFY/AUTH	DSN6SYSP	DSNTIPO3		G	IDAUTMOD
IDBACK	MAX BATCH CONNECT	DSN6SYSP	DSNTIPE	Yes	M	NUMCONBT
IDFORE	MAX TSO CONNECT	DSN6SYSP	DSNTIPE	Yes	M	NUMCONTS
IDTHTOIN	IDLE THREAD TIMEOUT	DSN6FAC		Yes	M	IDTHTOIN
IDXBPOOL	DEFAULT BUFFER POOL FOR USER INDEXES	DSN6SYSP	DSNTIP2	Yes	M	IDXBPOOL
IGNSORTN	IGNORE SORTNUM STMT	DSN6SPRM	DSNTIP6	Yes	M	IGNSORTN
IMMEDWRI	IMMEDIATE WRITE	DSN6GRP	DSNTIP8	Yes	—	IMMEDWRI
IMPDSDEF	DEFINE DATA SETS	DSN6SYSP	DSNTIP72	Yes	M	IMPDSDEF
IMPDSSIZE	—	DSN6SYSP	—	Yes	M	IMPDSIZE
IMPLICIT_TIMEZONE	IMPLICIT TIME ZONE	DSNHDECP	DSNTIP4		G	IMTZ
IMPTKMOD	—	DSN6SYSP	—	Yes	M	IMPTKMOD
IMPTSCMP	USE DATA COMPRESSION	DSN6SYSP	DSNTIP72	Yes	M	IMPTSCMP
INDEX_CLEANUP_THREADS	INDEX CLEANUP THREADS	DSN6SPRM	DSNTIPE1	Yes	M	IXCU
INDEX_MEMORY_CONTROL	INDEX MEMORY CONTROL	DSN6SPRM	DSNTIP71	Yes	G	IXMC
INLISTP	—	DSN6SPRM	—	Yes	M	INLISTP
IRLMPRC	PROC NAME	DSN6SPRM	DSNTIPI		U	IRLMPROC
IRLMRWT	RESOURCE TIMEOUT	DSN6SPRM	DSNTIPI		M	IRLMWAIT
IRLMSID	SUBSYSTEM NAME	DSN6SPRM	DSNTIPI		U	IRLMSSID
IX_TB_PART_CONV_EXCLUDE	EXCLUDE PART KEY COLUMNS	DSN6SPRM	DSNTIP72	Yes	—	XPKE
IXQTY	INDEX SPACE ALLOCATION	DSN6SYSP	DSNTIP7	Yes	G	IXQTY
LBACKOUT	LIMIT BACKOUT	DSN6SYSP	DSNTIPL1		M	LBACKOUT
LC_TYPE	LOCALE LC_CTYPE	DSNHDECP	DSNTIPF		G	LCCTYPE
LA_SINGLESEL_ISOCS_CDY	—	DSN6SPRM	—	Yes	G	LSSIC
LIKE_BLANK_INSIGNIFICANT	—	DSN6SPRM	—	Yes	G	LBIN
LOAD_DEL_IMPLICIT_SCALE	LOAD FORMAT DELIMITED IMPLICIT DECIMAL SCALE	DSN6SPRM	DSNTIP63	Yes	M	LDISCALE
LOAD RO OBJECTS	LOAD RO OBJECTS	DSN6SPRM	DSNTIP6		M	LIRO
LOB_INLINE_LENGTH	LOB INLINE LENGTH	DSN6SYSP	DSNTIPD	Yes	M	LOBINLEN
LRDRTHLD	LONG-RUNNING READER	DSN6SPRM	DSNTIPE	Yes	M	LRDRTHLD
MAINTYPE	CURRENT MAINT TYPES	DSN6SPRM	DSNTIP81	Yes	M	MAINTYPE
MATERIALIZE_NODET_SQLTUDF	—	DSN6SPRM	—	Yes	M	MNSU
MAXSORT_IN_MEMORY	MAX IN-MEMORY SORT SIZE	DSN6SPRM	DSNTIPC	Yes	M	ARHCMAX
MAX_CONCURRENT_PKG_OPS	—	DSN6SPRM	—	Yes	M	MXCONPKG
MAX_NUM_CUR	MAX OPEN CURSORS	DSN6SPRM	DSNTIPX	Yes	M	MXNUMCUR
MAX_ST_PROC	MAX STORED PROCS	DSN6SPRM	DSNTIPX	Yes	M	MXSTPROC
MAX_UDF	MAX UDFS	DSN6SPRM	DSNTIPX	Yes	M	MXUDF
MAXARCH	RECORDING MAX	DSN6LOGP	DSNTIPA		—	ARCHMAXV
MAXCONQN	CONN QUEUE MAX DEPTH	DSN6FAC	DSNTIP5	Yes	M	MAXCONQN
MAXCONQW	CONN QUEUE MAX WAIT	DSN6FAC	DSNTIP5	Yes	M	MAXCONQW
MAXDBAT	MAX REMOTE ACTIVE	DSN6SYSP	DSNTIPE	Yes	M	NUMCONRM
MAXKEEPD	MAX KEPT DYN STMTS	DSN6SPRM	DSNTIPE	Yes	M	MAXKEEPD
MAXOFILR	MAX OPEN FILE REFS	DSN6SYSP	DSNTIPE	Yes	M	MAXOFILR
MAXRBLK	RID POOL SIZE	DSN6SPRM	DSNTIPC	Yes	—	RIDPOOL
MAXRTU	READ TAPE UNITS	DSN6LOGP	DSNTIPA	Yes	M	ARCHMRTU
MAXTEMPS	MAX TEMP STG/AGENT	DSN6SPRM	DSNTIP91	Yes	M	MAXTEMPS
MAXTEMPS_RID	MAX TEMP RID	DSN6SPRM	DSNTIP91	Yes	M	MXTMPRID
MAXTYPE1	MAX INACTIVE DBATS	DSN6FAC		Yes	—	MAXTYPE1
MCCSID	EBCDIC CCSID	DSNHDECP	DSNTIPF		G	MCCSID
MEMBNAME	MEMBER NAME	DSN6GRP	DSNTIPK		U	MEMBNAME
MFA_AUTHCACHE_UNUSED_TIME	MFA AUTH UNUSED TIME	DSN6SPRM	DSNTIPP: Protection panel	Yes ³	G	MFAT
MINDVSCL	—	DSN6SPRM	—	Yes	—	MINDVSCL
MIXED	MIXED DATA	DSNHDECP	DSNTIPF		G	DEFMIXED
MON	MONITOR TRACE	DSN6SYSP	DSNTIPN		M	MON
MONSIZE	MONITOR SIZE	DSN6SYSP	DSNTIPN		M	MONSIZE
MOVE_TO_ARCHIVE_DEFAULT	—	DSN6SPRM	—	Yes	G	MOVE_TO_ARCHIVE_DEFAULT
MXDTCACH	MAX DATA CACHING	DSN6SPRM	DSNTIP81	Yes	M	MXDCACH
NPGTHRSH	—	DSN6SPRM	—	Yes	M	NPGTHRSH
NUMLKTS	LOCKS PER TABLE(SPACE)	DSN6SPRM	DSNTIPJ	Yes	M	IRLMLKTS
NUMLKUS	LOCKS PER USER	DSN6SPRM	DSNTIPJ	Yes	M	IRLMLKUS
OFFLOAD	—	DSN6LOGP	—	No	M	OFFLOAD
OPT1ROWBLOCKSORT	—	DSN6SPRM	—	Yes	—	OP1RBSRT
OPTHINTS	OPTIMIZATION HINTS	DSN6SPRM	DSNTIP8	Yes	M	OPTHINTS
OTC_LICENSE	OTC LICENSE USAGE	DSN6SYSP	DSNTIPO2		—	OTC_LICENSE
OUTBUFF	OUTPUT BUFFER	DSN6LOGP	DSNTIPL		M	OUTBUFF
PADIX	PAD INDEXES BY DEFAULT	DSN6SPRM	DSNTIP71	Yes	G	PADIX
PADNTSTR	PAD NUL-TERMINATED	DSNHDECP	DSNTIP4		M	PADNSTSR
PAGESET_PAGENUM	PAGE SET PAGE NUMBERING	DSN6SPRM	DSNTIP71	Yes	M	PSPN
PARA_EFF	PARALLELISM EFFICIENCY	DSN6SPRM	DSNTIP81	Yes	—	PARAEFF
PARAMDEG	MAX DEGREE	DSN6SPRM	DSNTIP81	Yes	M	PARAMDEG
PARAMDEG_DPSI	MAX DEGREE FOR DPSI	DSN6SPRM	DSNTIP81	Yes	M	DEGD
PARAMDEG_UTIL	MAX UTILS PARALLELISM	DSN6SPRM	DSNTIP6	Yes	G	UMD
PCTFREE_UPD	PERCENT FREE FOR UPDATE	DSN6SPRM	DSNTIP71	Yes	G	PFUP
PCLOSET	RO SWITCH TIME	DSN6SYSP	DSNTIPL1	Yes	M	PKRC
PEER_RECOVERY	PEER RECOVERY	DSN6GRP	DSNTIPK	Yes	M	PEERRRECO
PKGREL_COMMIT	PACKAGE RELEASE COMMIT	DSN6SPRM	DSNTIP8	Yes	M	PKRC
PLANMGMT	PLAN MANAGEMENT	DSN6SPRM	DSNTIP8	Yes	M	PLANMGMT
PLANMGMTSCOPE	PLAN MANAGEMENT SCOPE	DSN6SPRM	DSNTIP8	Yes	—	PMSCOPE
POOLINAC	POOL THREAD TIMEOUT	DSN6FAC	DSNTIP5	Yes	M	POOLINAC
PRIQTY	PRIMARY QUANTITY	DSN6ARVP	DSNTIPA	Yes	M	ARCHPRI
PREVENT_ALTERTB_LIMITKEY	PREVENT ALTER LIMITKEY	DSN6SPRM	DSNTIP72	Yes	G	PALK
PREVENT_NEW_IXCTRL_PART	—	DSN6SPRM	—	Yes	G	PCIP
PRIVATE_PROTOCOL	—	DSN6FAC	—	Yes	G	PRIVPRTL
PROFILE_AUTOSTART	PROFILE AUTOSTART	DSN6SYSP	DSNTIPO		M	PFAS
PROTECT	ARCHIVE LOG RACF	DSN6ARVP	DSNTIPP	Yes	M	PROTARAC
PTASKROL	—	DSN6SYSP	—	Yes	M	PTASKROL
QUERY_ACCEL_OPTIONS	ACCELERATION OPTIONS	DSN6SPRM	DSNTIP82	Yes	M	QACO
QUERY_ACCELERATION	CURRENT QUERY ACCEL	DSN6SPRM	DSNTIP82	Yes	M	QCAC
QUERY_ACCEL_WAITFORDATA	WAIT FOR DATA	DSN6SPRM	DSNTIP82	Yes	M	QAWFD
QUIESCE	QUIESCE PERIOD	DSN6ARVP	DSNTIPA	Yes	M	ARCHMQP
RANDOMATT	RANDOM ATTACH	DSN6GRP	DSNTIPK	Yes	M	RANDOMAT
REALSTORAGE_MANAGEMENT	MANAGE REAL STORAGE	DSN6SPRM	DSNTIPE1	Yes	M	RSMGMT
REALSTORAGE_MAX	—	DSN6SPRM	—	Yes	M	RSMAX
REC_FASTREPLICATION	FAST RESTORE	DSN6SPRM	DSNTIP61	Yes	M	RECFASRP
RECALL	RECALL DATABASE	DSN6SPRM	DSNTIPO		M	RECALL
RECALLD	RECALL DELAY	DSN6SPRM	DSNTIPO	Yes	M	RECALLD
REFSHAGE	CURRENT REFRESH AGE	DSN6SPRM	DSNTIP81	Yes	M	REFSHAGE
REMOTE_COPY_SW_ACCEL	REMOTE COPY SW ACCEL	DSN6LOGP	DSNTIPL	Yes	R	RCSA
RENAMETABLE	RENAME TABLE	DSN6SPRM	DSNTIP72	Yes	G	ERTS
REORG_DROP_PBG_PARTS	REORG DROP PBG PARTS	DSN6SPRM	DSNTIP63	Yes	M	RPBG
REORG_IC_LIMIT_DASD	REORG IC LIMIT DASD	DSNSPRM	DSNTIP63	Yes	M	RICLD
REORG_IC_LIMIT_TAPE	REORG IC LIMIT TAPE	DSNSPRM	DSNTIP63	Yes	M	RICLT
REORG_INDEX_NOSYSUT1	REORG INDEX NOSYSUT1	DSN6SPRM	DSNTIP63	Yes	M	RINSU
REORG_LIST_PROCESSING	REORG LIST PROCESSING	DSN6SPRM	DSNTIP63	Yes	M	RLPR
REORG_MAPPING_DATABASE	REORG MAPPING DB	DSN6SPRM	DSNTIP6	Yes	M	RMDB
REORG_PART_SORT_NPSI	REORG PART SORT NPSI	DSN6SPRM	DSNTIP63 DSNTIP62	Yes	M	RPSN
RESTART	RESTART OR DEFER	DSN6SPRM	DSNTIPS		M	RESTART
RESTORE_RECOVER_FROMDUMP	RESTORE/RECOVER	DSN6SPRM	DSNTIP62	Yes	M	RESRECFD
RESTORE_TAPEUNITS	MAXIMUM TAPE UNITS	DSN6SPRM	DSNTIP62 DSNTIP6	Yes	M	RESTORTU
REORG_TS_NOPAD_DEFAULT	REORG TS NOPAD DEFAULT	DSN6SPRM	DSNTIP62	Yes	M	REONOPAD
RESTRICT_ALT_COL_FOR_DCC	—	DSN6SPRM	—	Yes	M	RACFD
RESYNC	RESYNC INTERVAL	DSN6FAC	DSNTIPR	Yes	M	RESYNC
RETLWAIT	RETAINED LOCK TIMEOUT	DSN6SPRM	DSNTIPI	Yes	M	RETLWAIT
RETRY_STOPPED_OBJECT	RETRY STOPPED OBJECTS	DSN6SPRM	DSTIP72		G	RSO
REVOKE_DEP_PRIVILEGES	REVOKE DEP PRIV	DSN6SPRM	DSNTIPP1	Yes ³	G	REVDPRIV
RGFCOLID	REGISTRATION OWNER	DSN6SPRM	DSNTIPZ		G	RGFCOLID
RGFDBNAM	REGISTRATION DATABASE	DSN6SPRM	DSNTIPZ		G	RGFDBNAM
RGFDEDPL	CONTROL ALL APPLICATIONS	DSN6SPRM	DSNTIPZ		G	RGFDEDPL
RGFDEFLT	UNREGISTERED DDL DEFAULT	DSN6SPRM	DSNTIPZ		G	RGFDEFLT
RGFESCP	ART/ORT ESCAPE CHARACTER	DSN6SPRM	DSNTIPZ		M	RGFESCP
RGFFULLQ	REQUIRE FULL NAMES	DSN6SPRM	DSNTIPZ		G	RGFFULLQ
RGFINSTL	INSTALL DD CONTROL SUPT	DSN6SPRM	DSNTIPZ		G	RGFINSTL
RGFNMORT	OBJT REGISTRATION TABLE	DSN6SPRM	DSNTIPZ		G	RGFNMORT
RGFNMPRT	APPL REGISTRATION TABLE	DSN6SPRM	DSNTIPZ		G	RGFNMPRT
RLF	RLF AUTO START	DSN6SYSP	DSNTIPO4		M	RLFSTART
RLFENABLE	RLF SCOPE	DSN6SYSP	DSNTIPO4	Yes	R	RLFSCOPE
RLFAUTH	RESOURCE AUTHID	DSN6SYSP	DSNTIPP1	Yes	M	PROTRLF
RLFERR	DYNAMIC SQL	DSN6SYSP	DSNTIPO4	Yes	M	RLFERROR
RLFERRD	REMOTE DYNAMIC SQL	DSN6FAC	DSNTIPO4	Yes	M	RLFERRD
RLFERRSTC	STATIC SQL	DSN6SYSP	DSNTIPO4	Yes	M	RLFERRST
RLFERRDSTC	REMOTE STATIC SQL	DSN6FAC	DSNTIPO4	Yes	M	RLFERRST
RLFTBL	RLST NAME SUFFIX	DSN6SYSP	DSNTIPO4	Yes	M	RLFSUFF
ROUTCDE	WTO ROUTE CODES	DSN6SYSP	DSNTIPO		M	OPROUTCD
RRULOCK	U LOCK FOR RR/RS	DSN6SPRM	DSNTIPI	Yes	M	RRULOCK
SCCSID	EBCDIC CCSID	DSNHDECP	DSNTIPF		G	SCCSID
SECADM1	SECURITY ADMIN 1	DSN6SPRM	DSNTIPP1	Yes ³	G	SECADM1
SECADM1_INPUT_STYLE	—	DSN6SPRM	—	Yes	G	SECA1IS
SECADM1_TYPE	SEC ADMIN 1 TYPE	DSN6SPRM	DSNTIPP1	Yes ³	G	SECAMD1T
SECADM2	SECURITY ADMIN 2	DSN6SPRM	DSNTIPP1	Yes ³	G	SECADMN2
SECADM2_INPUT_STYLE	—	DSN6SPRM	—	Yes	G	SECA2IS
SECADM2_TYPE	SEC ADMIN 2 TYPE	DSN6SPRM	DSNTIPP1	Yes ³	G	SECADM2T
SECQTY	SECONDARY QTY	DSN6ARVP	DSNTIPA	Yes	M	ARCHSEC
SEPARATE_SECURITY	SEPARATE SECURITY	DSN6SPRM	DSNTIPP1	Yes ³	G	SEPSECUR
SIGNON_MODULE	SIGNON	DSN6SYSP	DSNTIPO3		G	SIGNON
SIMULATED_CPU_COUNT	—	DSN6SPRM	—	Yes	G	SIMCCNT
SIMULATED_CPU_SPEED	—	DSN6SPRM	—	Yes	G	SIMCSPD
SITETYP	SITE TYPE	DSN6SPRM	DSNTIPO		G	SITETYP
SJTABLES	—	DSN6SPRM	—	Yes	M	SJTABLES
SKIPUNCI	SKIP UNCOMM INSERTS	DSN6SPRM	DSNTIP8	Yes	G	SKIPUNCI
SMF89	—	DSN6SYSP	—	Yes	—	SMF89
SMFACCT	SMF ACCOUNTING	DSN6SYSP	DSNTIPN		M	OPSMFACT
SMFCOMP	COMPRESS SMF RECS	DSN6SYSP	DSNTIPN	Yes	M	SMFCOMP
SMFSTAT	SMF STATISTICS	DSN6SYSP	DSNTIPN		M	OPSMFSTA
SQLDELI	SQL STRING DELIMITER	DSNHDECP	DSNTIPF		G	DEFSQSTR
SQLLEVEL	PRECOMPILER SQL LEVEL	DSNHDECP	DSNTIP00	Yes ⁵	G	SQLL
SRTPOOL	SORT POOL SIZE	DSN6SPRM	DSNTIPC	Yes	M	SRTPOOL
SSID	SUBSYSTEM NAME	DSNHDECP	DSNTIPM		U	MVSSNAME
STARJOIN	STAR JOIN QUERIES	DSN6SPRM	DSNTIP81	Yes	M	STARJOIN
STATCLGSRT	STATISTICS COLGROUP DATA SORT	DSN6SPRM	DSNTIP6	Yes	M	STCS
STATFDBK_PROFILE	STATISTICS PROFILE FEEDBACK	DSN6SPRM	DSNTIP8	Yes	G	SFPR
STATFDBK_SCOPE	STATISTICS FEEDBACK	DSN6SPRM	DSNTIP8	Yes	G	SFBS
STATHIST	STATISTICS HISTORY	DSN6SPRM	DSNTIP6 DSNTIP61	Yes	G	STATHIST
STATIME	STATISTICS TIME	DSN6SYSP	DSNTIPN	Yes	M	OPSTATIM
STATIME_DDF	DDF STATS TIME	DSN6SYSP	DSNTIPN	Yes	M	OPSTATMD
STATIME_MAIN	MAIN STATS TIME	DSN6SYSP	DSNTIPN	Yes	M	OPSTATMM
STATPGSAMP	PAGE-LEVEL SAMPLING	DSN6SPRM	DSNTIP6	No	M	STPGSAM
STATROLL	STATISTICS ROLLUP	DSN6SPRM	DSNTIP6	Yes	G	STATROLL
STATSINT	REAL TIME STATS	DSN6SPRM	DSNTIP8	Yes	G	STATSINT
STDSQL	STD SQL LANGUAGE	DSNHDECP	DSNTIP4		G	DEFSQLVL
STORMXAB	MAX ABEND COUNT	DSN6SYSP	DSNTIPX	Yes	M	STORMXAB
STORTIME	TIMEOUT VALUE	DSN6SYSP	DSNTIPX	Yes	M	STORTIME
SUBQ_MIDX	—	DSN6SPRM	—	Yes	—	SUBQ_MIDX
SUBSTR_COMPATIBILITY	SUBSTR COMPATIBILITY	DSN6SPRM	DSNTIPX	Yes	G	SUBSTRCP
SUPERRS	SUPPRESS SOFT ERRORS	DSN6SPRM	DSNTIPM	Yes	M	SUPERRS
SUPPRESS_HINT_SQLCODE_DYN	—	DSN6SPRM	—	Yes	M	SHSD
SVOLARC	SINGLE VOLUME	DSN6ARVP	DSNTIPA	Yes	M	SVOLARC
SYNCVAL	STATISTICS SYNC	DSN6SYSP	DSNTIPN	Yes	M	SYNCVAL
SYSADM	SYSTEM ADMIN 1	DSN6SPRM	DSNTIPP1	Yes ³	G	PROTADMN
SYSADM2	SYSTEM ADMIN 2	DSN6SPRM	DSNTIPP1	Yes ³	G	PROTADM2
SYSOPR1	SYSTEM OPERATOR 1	DSN6SPRM	DSNTIPP1	Yes ³	G	PROTOPR1
SYSOPR2	SYSTEM OPERATOR 2	DSN6SPRM	DSNTIPP1	Yes ³	G	PROTOPR2
SYSTEM_LEVEL_BACKUPS	SYSTEM-LEVEL BACKUPS	DSN6SPRM	DSNTIP62 DSNTIP6	Yes	M	SYSLVLBK
TBSBP8K	DEFAULT 8-KB BUFFER POOL FOR USER DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBP8K
TBSBP16K	DEFAULT 16-KB BUFFER POOL FOR USER DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBP16K
TBSBP32K	DEFAULT 32-KB BUFFER POOL FOR USER DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBP32K
TBSBPLOB	DEFAULT BUFFER POOL FOR USER LOB DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBPLOB
TBSBPOOL	DEFAULT 4-KB BUFFER POOL FOR USER DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBPOOL
TBSBPXML	DEFAULT BUFFER POOL FOR USER XML DATA	DSN6SYSP	DSNTIP2	Yes	M	TBSBPXML
TCPALVER	TCP/IP ALREADY VERIFIED	DSN6FAC	DSNTIP5	Yes ³	G	TCPALVER
TCPKPALV	TCP/IP KEEPALIVE	DSN6FAC	DSNTIP5	Yes ³	M	TCPKPALV
TEMPLATE_TIME	TEMPLATE TIME	DSN6SPRM	DSNTIP6	Yes	G	TPTM
TIME	TIME FORMAT	DSNHDECP	DSNTIP4		G	DEFTIME
TIMELEN	LOCAL TIME LENGTH	DSNHDECP	DSNTIP4		G	DEFTIMEL
TRACSTR	TRACE AUTO START	DSN6SYSP	DSNTIPN		M	OPTRCAUT
TRACTBL	TRACE SIZE	DSN6SYSP	DSNTIPN		M	CALC/OPTRCSIZ
TRKRSITE	TRACKER SITE	DSN6SPRM	DSNTIPO		G	TRKRSITE
TS_COMPRESSION_TYPE	TS COMPRESSION TYPE	DSN6SPRM	DSNTIP7	Yes	G	--
TSQTY	TABLE SPACE ALLOCATION	DSN6SYSP	DSNTIP7	Yes	G	TSQTY
TSTAMP	TIMESTAMP ARCHIVES	DSN6ARVP	DSNTIPH	Yes	M	ARCHTS
TWOACTV	NUMBER OF COPIES	DSN6LOGP	DSNTIPH		M	CALC/LOGSTWO
TWOARCH	NUMBER OF COPIES	DSN6LOGP	DSNTIPH		M	CALC/ARCHTWO
TWOBSDS	—	DSN6LOGP	—		—	TWOBSDS
UGCCSID	UNICODE CCSID	DSNHDECP	DSNTIPF		G	UGCCSID
UIFCIDS	UNICODE IFCIDS	DSN6SYSP	DSNTIPN	Yes	G	UIFCIDS
UMCCSID	UNICODE CCSID	DSNHDECP	DSNTIPF		G	UMCCSID
UNION_COLNAME_7	—	DSN6SPRM	—	Yes	M	UNCOLN7
UNIT	DEVICE TYPE 1	DSN6ARVP	DSNTIPA	Yes	M	ARCHDEVT
UNIT2	DEVICE TYPE 2	DSN6ARVP	DSNTIPA	Yes	M	ARCHDEV2
URCHKTH	UR CHECK FREQ	DSN6SYSP	DSNTIPL1	Yes	M	URCHKTH
URLGWTH	UR LOG WRITE CHECK	DSN6SYSP	DSNTIPL1	Yes	M	URLGWTH
USCCSID	UNICODE CCSID	DSNHDECP	DSNTIPF		G	USCCSID
UTIL_DBBSG	DB BACKUP STG GROUP	DSN6SPRM	DSNTIP62	Yes	G	UDBSG
UTIL_LGBSG	LOG BACKUP STG GRP	DSN6SPRM	DSNTIP62	Yes	G	ULBSG
UTIL_TEMP_STORCLAS	UTIL TEMP STORCLAS	DSN6SPRM	DSNTIP6	Yes	G	UTTEMPSC
UTILS_HSM_MSGDS_HLQ	HSM MESSAGE DS HLQ	DSN6SPRM	DSNTIP62	Yes	G	UHMDH
UTILS_BLOCK_FOR_CDC	UTILS BLOCK FOR CDC	DSN6SPRM	DSNTIP6	Yes	M	UBCDC
UTILS_DUMP_CLASS_NAME	DUMP CLASS NAME	DSN6SPRM	DSNTIP62 DSNTIP61	Yes	M	UTDUMPCL
UTILS_USE_ZSORT	UTILS USE ZSORT	DSN6SPRM	DSNTIP63	Yes	M	UZSORT
UTIMOUT	UTILITY TIMEOUT	DSN6SPRM	DSNTIP6 DSNTP61	Yes	M	UTIMOUT
VOLTDEVT	TEMP DS UNIT NAME	DSN6SPRM	DSNTIP6	Yes	M	VOLTDEVT
WFDBSEP	SEPARATE WORK FILES	DSN6SPRM	DSNTIP91		M	WFDBSEP
WFSTGUSE_AGENT_THRESHOLD	AGENT LEVEL THRESHOLD	DSN6SPRM	DSNTIP91	Yes	M	WFSAT
WFSTGUSE_SYSTEM_THRESHOLD	SYSTEM LEVEL THRESHOLD	DSN6SPRM	DSNTIP91	Yes	M	WFSST
WLMENV	WLM ENVIRONMENT	DSN6SYSP	DSNTIPX	Yes	M	WLMENV
XLKUPDLT	X LOCK FOR SEARCHED U/D	DSN6SPRM	DSNTIPI	Yes	M	XLKUPDLT
XML_RANDOMIZE_DOCID	RANDOMIZE XML DOCID	DSN6SYSP	DSNTIP8	Yes	G	XRDI
XML_RESTRICT_EMPTY_TAG	—	DSN6SPRM	—	Yes	—	NOET
ZOSMETRICS	—	DSN6SPRM	—	Yes	M	ZOSMETRI
ZHYPERLINK	DB2 zHyperLinks SCOPE	DSN6SPRM	DSNTIPA3	Yes	M	ZHYPL
—	ADVANCED CONFIGURATION OPTIONS	—	DSNTIPR1		—	—
—	APPL DEFAULTS	—	DSNTIPO3		—	—
—	APPLICATION DBRM	—	DSNTIPT		M	DBRMLIB
—	APPLICATION LOAD	—	DSNTIPT		M	RUNLIB
—	ARCHIVE LOG FREQ	—	DSNTIPL		M	NUMHRARC
—	AUTH MEMBER	—	DSNTIPM		M	MVSAMEMB
—	AUTH SEQUENCE	—	DSNTIPM		M	MVSASEQN
—	BP0 - BP49	—	DSNTIP1		M	BP0 - BP29
—	BP8K0 - BP32K9	—	DSNTIP2		M	BP30 - BP32K9
—	BSDS AND ACTIVE LOG ICF CATALOG ALIAS	—	DSNTIPA4: BSDS and active log panel		G	VBSDSLOG
—	BUFFER POOL SIZE	—	DSNTIPC		—	—
—	BYTE-BASED STRING FUNCTIONS	—	DSNTIP8A	Yes	—	—
—	C LE PRELINKER PHASE	—	DSNTIPU		M	—
—	CICS® and IMS transaction invocation routines (DSNTIPRN)	—	DSNTIPRA		—	—
—	CICS COBOL LIBRARY	—	DSNTIPW		G	CICSCOB
—	CICS EXCI LIBRARY	—	DSNTIPW		G	CICSEXCI
—	CICS LOAD LIBRARY	—	DSNTIPW		G	CICSMOD
—	CICS MACRO LIBRARY	—	DSNTIPW		G	CICSMAC
—	CICS PL/I LIBRARY	—	DSNTIPW		G	CICSPLI
—	C/CPP COMPILER LIBRARY>	—	DSNTIPU		M	CCOMP
—	C/CPP COMPILER MODULE	—	DSNTIPU		M	CPROG
—	C/CPP HEADER LIBRARY	—	DSNTIPU		M	CHDRS
—	C/370 COMPILER MESSAGES	—	DSNTIPU		M	CMSGS
—	CLIST ALLOCATION	—	DSNTIPA2		M	VOLSDAT1
—	CLIST LIBRARY	—	DSNTIPT		M	OUTCL
—	COBOL COMPILER LIBRARY	—	DSNTIPU1		M	ICOBCOMP
—	COBOL LE PRELINKER PHASE	—	DSNTIPU1		M	ICOBPRLK
—	COLUMNS	—	DSNTIPD		M	—
—	COMMAND PREFIX	—	DSNTIPM		U	MVSSPREF
—	COMMAND SCOPE	—	DSNTIPM		M	CMDSCOPE
—	COPY 1 NAME	—	DSNTIPH		U	BSDSNAM1
—	COPY 2 NAME	—	DSNTIPH		U	BSDSNAM2
—	Active logs: COPY 1 PREFIX	—	DSNTIPH		U	LOGSPRE1
—	Active logs: COPY 2 PREFIX	—	DSNTIPH		U	LOGSPRE2
—	CPP AUTO CALL LIBRARY	—	DSNTIPU		M	CPPAUTCL
—	CPP CLASS LIB HEADERS	—	DSNTIPU		M	CPPHDRS
—	CPP CLASS LIBRARY	—	DSNTIPU		M	CPPCLASS
—	CPP LE PRELINKER PHASE	—	DSNTIPU		M	—
—	CPP PROCEDURE LIBRARY	—	DSNTIPU		M	CPPPROC
—	CURRENT FUNCTION LEVEL	—	DSNTIP00		—
—	DATA SET NAME PREFIX	—	DSNTIPA1		—	DSNILIBP
—	DATA SET NAME SUFFIX	—	DSNTIPA1		—	DSNILIBS
—	DATA SET OR LIBRARY QUALIFIER	—	DSNTIPAP		G	AGNEWIDS
—	DATABASES	—	DSNTIPD		M	—
—	Database metadata routines (DSNTIPRK)	—	DSNTIPRA		—	—
—	DATABASES	—	DSNTIPE		M	—
—	DATABASE AND TABLESPACE STORAGE GROUP	—	DSNTIG1		—
—	DBRM LIBRARY	—	DSNTIPT		M	DSNDBRM
—	DB2 administrator routines (DSNTIPRL)	—	DSNTIPRA		—	—
—	DB2 BASE Java™ DIR	—	DSNTIPX1		G	—
—	DB2 COMMAND PREFIX FIRST CHARACTER	—	DSNTIPAP		G	AGSSIDPX
—	DB2 GENERIC LUNAME	—	DSNTIPR		G	GENLUNM
—	TARGET FUNCTION LEVEL	—	DSNTIP00		—	FUNCLVL
—	DB2 LOCATION NAME	—	DSNTIPR		G	DDLOC
—	DB2 optimization routines (DSNTIPRM)	—	DSNTIPRA		—	—
—	DB2 security routines (DSNTIPRE)	—	DSNTIPRA		—	—
—	DB2 TCP/IP IPNAME	—	DSNTIPR		G	IPNAME
—	DB2 VTAM® LUNAME	—	DSNTIPR		M	DDLUNAM
—	DB2 VTAM PASSWORD	—	DSNTIPR		M	DDPASS
—	DD/MM/YYYY LOCAL DATE FORMAT	—	DSNTIP8A	Yes	—	—
—	DEADLOCK CYCLE	—	DSNTIPJ		M	—
—	DEADLOCK TIME	—	DSNTIPJ		M	—
—	DECLARATION LIBRARY	—	DSNTIPT		M	SRCLIB
—	DEFINE CATALOG	—	DSNTIPA2		G	—
—	DISCONNECT IRLM	—	DSNTIPJ		M	IRLMDISC
—	ENGLISH TASK AND PANELS LIBRARY	—	DSNTIPAP		M	DSNPFPE
—	Enter job card information for install and sample jobs	—	DSBNTIPY		M	—
—	EXECUTED STMTS	—	DSNTIPD		M	NUMSTMTE
—	EXIT LIBRARY	—	DSNTIPT		M	DSNEXIT
—	FAVOR NEW ACCELERATOR_TYPE	—	DSNTIP8A	Yes	—	—
—	FOR DB2 REXX ROUTINES	—	DSNTIPR1		M	WLMENVR
—	FOR DB2 UTILITIES ROUTINES	—	DSNTIPR1		M	WLMENVU
—	FOR DB2 XML PROCESSING ROUTINES	—	DSNTIPR1		M	WLMENVX
—	FOR MOST DB2 ROUTINES	—	DSNTIPR1		M	WLMENVG
—	FOR MOST DB2 JAVA ROUTINES	—	DSNTIPR1		M	WLMENVJ
—	FOR ROUTINES IDENTIFIED TO PROGRAM CONTROL	—	DSNTIPR1		M	WLMENVP
—	FOR SERIALIZED ROUTINES	—	DSNTIPR1		M	WLMENV1
—	FOR THE DB2 CICS ROUTINE	—	DSNTIPR1		M	WLMENVC
—	FOR DB2 MQSERIES ROUTINES	—	DSNTIPR1		M	WLMENVM
—	FOR DB2 WEB SERVICES ROUTINES	—	DSNTIPR1		M	WLMENVW
—	FOR UNIFIED DEBUGGER ROUTINES	—	DSNTIPR1		M	WLMENVD
—	GDDM LOAD MODULES	—	DSNTIPW		M	GDDMLOAD
—	GDDM MACLIB	—	DSNTIPW		M	GDDMMACS
—	GRANT EXECUTE (on many sub-panels)	—	DSNTIPRA (sub-panels)		—	—
—	GROUP ATTACH	—	DSNTIPK		G	GRPATTNM
—	HIGH LEVEL ASSEMBLER LIB	—	DSNTIPU		M	ASMLIB
—	IC DATA SET UNIT NAME	—	DSNTIPG1		G	—
—	IC TEMPLATE DATA CLASS	—	DSNTIPG1		G	—
—	IC TEMPLATE EXPRESSION	—	DSNTIPG1		G	—
—	IC TEMPLATE MGMT CLASS	—	DSNTIPG1		G	—
—	IC TEMPLATE STOR CLASS	—	DSNTIPG1		G	—
—	IBM LE LINK EDIT LIB	—	DSNTIPU		M	LELKED
—	IBM LE PRELINK MSG LIB	—	DSNTIPU		M	LEPLMSGL
—	IBM LE RUNTIME LIBRARY	—	DSNTIPU		M	LERUN
—	IBM LE RUNTIME LIBRARY 2	—	DSNTIPU		M	LERUN2
—	IBM Text Search routines (DSNTIPRJ)	—	DSNTIPRA		—	—
—	IMS RESLIB	—	DSNTIPW		M	RESLIB
—	INCLUDE LIBRARY	—	DSNTIPT		M	DSNCHDRS
—	INDEX SPACE STORAGE GROUP	—	DSNTIG1		—
—	INIT JAVA HEAP SIZE	—	DSNTIPX1		G	—
—	INPUT MEMBER NAME	—	DSNTIPA1		—	—
—	INSERT FROM SELECT	—	DSNTIP8A	Yes	—	—
—	INSTALL GRANTEE(S)	—	DSNTIPG		M	INSGRLST
—	INSTALL IC PREFIX	—	DSNTIPG1		M	INSICPRE
—	INSTALL IRLM	—	DSNTIPG		M	—
—	INSTALL DS PREFIX	—	DSNTIPG1		M	INSDSPRE
—	INSTALL PKG OWNER	—	DSNTIPG		G	INSPKOWN
—	INSTALL SQL ID	—	DSNTIPG		G	INSSQLID
—	INSTALL TYPE	—	DSNTIPA1		—	INSTYPE
—	IRLM LOAD LIBRARY	—	DSNTIPT		M	DSNIRLM
—	IRLM XCF GROUP NAME	—	DSNTIPJ		G	IRLMGRPN
—	ISPF COMMAND TABLE LIBRARY	—	DSNTIPAP		M	DSNSPFT
—	ISPF INSTALL TASK AND PANELS LIBRARY	—	DSNTIPAP		M	DSNSPFP
—	ISPF ISPLINK MODULE	—	DSNTIPW		M	ISPLOAD
—	ISPF MESSAGE LIBRARY	—	DSNTIPAP		M	DSNSPFM
—	ISPF SKELETON LIBRARY	—	DSNTIPAP		M	DSNSPFS
—	IVP DATA LIBRARY	—	DSNTIPT		M	DSNIVPD
—	IVP GRANTEE	—	DSNTIPG		M	—
—	IVP PKG OWNER	—	DSNTIPG		M	IVPGRLST
—	IVP SQL ID	—	DSNTIPG		G	IVPPKOWN
—	Java and SQL procedure processing routines (DSNITPRF)	—	DSNTIPRA		G	IVPSQLID
—	Java ENV DATA SET	—	DSNTIPX1		G	—
—	Java ENV VAR FILE	—	DSNTIPX1		G	—
—	JDBC AND SQLJ DLLS	—	DSNTIPT		M	DSNLOD2
—	JDBC/SQLJ ENV VAR DIR	—	DSNTIPX1		G	—
—	JDBC/SQLJ INSTALL ID	—	DSNTIPX1		G	—
—	JSON routines (DSNTIPRQ)	—	DSNTIPRA		—	—
—	JVM ADDRESSING MODE	—	DSNTIPX1		G	—
—	JVM PROPERTIES FILE	—	DSNTIPX1		G	—
—	LIBRARY NAME PREFIX	—	DSNTIPA1		—	DSNTLIBP
—	LIBRARY NAME SUFFIX	—	DSNTIPA1		—	DSNTLIBS
—	LICENSE TERMS ACCEPTED	—	DSNTIPO2		—	—
—	LINK LIST ENTRY	—	DSNTIPM		M	MVSLMEMB
—	LINK LIST LIBRARY	—	DSNTIPT		M	DSNLINK
—	LINK LIST SEQUENCE	—	DSNTIPM		M	MVSLSEQN
—	LOAD LIBRARY	—	DSNTIPT		M	DSNLOAD
—	LOCK ENTRY SIZE	—	DSNTIPJ		M	IRLMLKSZ
—	LOG COPY 1, BSDS 2	—	DSNTIPA4		M	VOLSDAT6 DATACLS6 MGMTCLS6 STORCLS6
—	LOG COPY 2, BSDS 1	—	DSNTIPA4		M	VOLSDAT7 DATACLS7 MGMTCLS7 STORCLS7
—	MBCS EBCDIC	—	DSNTIP8A	Yes	—	—
—	MEMBER IDENTIFIER	—	DSNTIPJ		U	IRLMIDEN
—	NON-VSAM DATA	—	DSNTIPA3		M	VOLSDAT2 DATACLS2 MGMTCLS2 STORCLS2
—	MACRO LIBRARY	—	DSNTIPT		M	DSNMACS
—	MAX APPL HEAP SIZE	—	DSNTIPX1		G	—
—	MAX STORAGE FOR LOCKS	—	DSNTIPJ		M	—
—	MQseries routines (DSNTIPRO)	—	DSNTIPRA		—	—
—	NUMBER OF LOCK ENTRIES	—	DSNTIPJ		M	IRLMLTE
—	NUMBER OF LOGS	—	DSNTIPL		M	LOGSNUM
—	NUMBER OF TCBS	—	DSNTIPX		M	STORTCBS
—	OTC LICENSE USAGE	—	DSNTIPO1		—	—
—	OUTPUT MEMBER NAME	—	DSNTIPA1		—	—
—	PACKAGE LISTS	—	DSNTIPD		M	—
—	GRANT OWNER (on many sub-panels)	—	DSNTIPRA (sub-panels)		—	—
—	PACKAGE STATEMENTS	—	DSNTIPD		M	—
—	PACKAGES	—	DSNTIPD		M	—
—	PAGE PROTECT	—	DSNTIPJ		M	IRLMPGPR
—	PARAMETER MODULE	—	DSNTIPO3		U	DSNZPARM
—	PERMANENT UNIT NAME	—	DSNTIPA3		M	VOLSDEVT
—	PKG APPLCOMPAT	—	DSNTIPG1		JRPMGT
—	PKG PLANMGMT	—	DSNTIPG1		JRTAPCO
—	PLAN STATEMENTS	—	DSNTIPD		M	—
—	PLANS	—	DSNTIPD		M	—
—	PL/I COMPILER LIBRARY	—	DSNTIPU1		M	PLICOMP
—	PL/I LE PRELINKER PHASE	—	DSNTIPU1		M	PLIPRLK
—	PROVISION EXEC ID	—	DSNTIPG: Installation preferences panel		G	AGEXECID
—	REMOTE LOCATION	—	DSNTIPY		M	—
—	RESYNC PORT	—			U	RESYNPRT
—	ROUTINES CREATOR	—	DSNTIPG		G	AUTHID
—	SAMPLE LIBRARY	—	DSNTIPT		M	NEWSAMP
—	SECURE PORT	—			G	SECPORT
—	SEC DEF CREATOR	—	DSNTIPG		G	SECDEFID
—	START IRLM CTRACE	—	DSNTIPJ		M	—
—	SOFTWARE SERVICE INSTANCE NAME PREFIX	—	DSNTIPAP		G	—
—	SORT LIBRARY	—	DSNTIPW		M	SORTLIB
—	SUBGRP ATTACH	—	DSNTIPK		M	SGRPATNM
—	SUBSYSTEM MEMBER	—	DSNTIPM		M	MVSSMEMB
—	SUBSYSTEM SEQUENCE	—	DSNTIPM		U	MVSSSEQN
—	SYSTEM MACLIB	—	DSNTIPW		M	MACLIB
—	SYSTEM PROCEDURES	—	DSNTIPW		M	PROCLIB
—	SYSTEM_TIME TEMPORAL QUERIES	—	DSNTIP8A	Yes	—	—
—	TABLES	—	DSNTIPD		M	—
—	TABLES IN STMT	—	DSNTIPD		M	—
—	TABLESPACES	—	DSNTIPD		M	—
—	TCP/IP PORT	—	DSNTIPR: Distributed data facility panel 1		G	TCPPORT
—	TEMP CLIST LIBRARY	—	DSNTIPT		M	—
—	TEMPORARY UNIT NAME	—	DSNTIPA3		M	TVOLDEVT
—	Trace formatting routines (DSNTIPRB)	—	DSNTIPRA		—	—
—	TS COLS WITH PRECISION OF 12	—	DSNTIP8A	Yes	—	—
—	UPDATE RATE	—	DSNTIPL		M	NUMCOMHR
—	Unified debugger for Java and SQL routines (DSNTIPRH)	—	DSNTIPRA		M	—
—	USE ZOSMF WORKFLOW	—	DSNTIPA1		—	—
—	Utility invocation routines (DSNTIPRC)	—	DSNTIPRA		—	—
—	VSAM CATALOG, DEFAULT AND WORK FILE DATABASE	—	DSNTIPA3		M	VOLSDAT3 DATACLS3 MGMTCLS3 STORCLS3
—	VIEWS	—	DSNTIPD		M	—
—	Web services/SOAP routines (DSNTIPRP)	—	DSNTIPRA		—	—
—	WLM ENV NAME (on many sub-panels)	—	DSNTIPRA (sub-panels)		—	—
—	WLM PROC NAME	—	DSNTIPX		M	STORWLM
—	WORK FILE DB	—	DSNTIPK		U	WKDBNAME
—	XML schema processing routines IVP(DSNTIPRI)	—	DSNTIPRA		—	—
—	Z/OS SDK HOME DIR	—	DSNTIPX1		G	—
—	Z/OS USS Java CLASSES	—	DSNTIPX1		G	—
—	Z/OS USS Java RUNTIME	—	DSNTIPX1		G	—
—	4K SORT PRIMARY SPACE	—	DSNTIP9		M	S4KSPAC
—	4K SORT WORK TS'S		DSNTIP9		M	S4KNOTS
—	4K SORT WORK SEG SIZE	—	DSNTIP9		M	S4KSGSZ
—	4K TEMP PRIMARY SPACE		DSNTIP9		M	T4KSPAC
—	4K TEMP WORK TS'S	—	DSNTIP9		M	T4KNOTS
—	4K TEMP WORK SEG SIZE	—	DSNTIP9		M	T4KSGSZ
—	32K SORT PRIMARY SPACE	—	DSNTIP9		M	S32KSPAC
—	32K SORT WORK TS'S	—	DSNTIP9		M	S32KNOTS
—	32K SORT WORK SEG SIZE		DSNTIP9		M	S32KSGSZ
—	32K TEMP PRIMARY SPACE	—	DSNTIP9		M	T32KSPAC
—	32K TEMP WORK TS'S	—	DSNTIP9		M	T32KNOTS
—	32K TEMP WORK SEG SIZE	—	DSNTIP9		M	T32KSGSZ

Notes

For use only when migrating or installing Db2 by using z/OSMF workflows. For more information, see Automating Db2 installation or migration with z/OS Management Facility .
The DS column indicates the data sharing scope of each subsystem parameter:

G

The subsystem parameter has group scope. This means that the subsystem parameter value must be the same for all members of a data sharing group.

M, U, or R

The subsystem parameter has member scope. Variations of member scope are:

M

The subsystem parameter value can be the same for all, some, or none of the members of the data sharing group.

U

The subsystem parameter value must be unique for each member of the data sharing group.

R

The subsystem parameter value can be different on some members of the data sharing group, but it is recommended to be the same on all members.
You must use a process with a privilege set that includes installation SYSADM authority or SECADM authority. For more information, see Security parameters.
This subsystem parameter can only be changed online. Restarting Db2 has no effect on the setting.
For online updates the SQLLEVEL, the precompiler and coprocessor begin using the new value immediately. However, the SYSIBM.DEFAULT_SQLLEVEL global variable value is not updated until Db2 is restarted.

Security parameters

To change the following security-related subsystem parameters, the privilege set of the process must include installation SYSADM authority or SECADM authority:

Security-related parameters

The following subsystem parameters are security-related parameters, but they do not have the same privilege-set requirements as the security parameters described previously.