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 ADb2 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 DS2 DSNTIDxx entry or z/OSMF variable 1
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 3 M AUDIT
AUTH USE PROTECTION DSN6SPRM DSNTIPP No 3 M PROTAUTH
AUTHEXIT_CACHEREFRESH AUTH EXIT CACHE REFR DSN6SPRM DSNTIPP No 3 G AECR
AUTH_COMPATIBILITY — DSN6SPRM — Yes M AUTCMPAT
AUTHEXIT_CHECK AUTH EXIT CHECK DSN6SPRM DSNTIPP No 3 G RACK
BACKODUR BACKOUT DURATION DSN6SYSP DSNTIPL1   M BACKODUR
BIF_COMPATIBILITY BIF COMPATIBILITY DSN6SPRM DSNTIPX Yes — BIFCP
BINDNV BIND NEW PACKAGE DSN6SPRM DSNTIPP1 Yes 3 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 DSNTIP5: Distributed data facility panel 2   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 3 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
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 3 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
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
EXTSEC EXTENDED SECURITY DSN6SYSP DSNTIP5: Distributed data facility panel 2 Yes 3 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
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 DSNTIP5: Distributed data facility panel 2 Yes M IDTHTOIN
IDXBPOOL DEFAULT BUFFER POOL FOR USER INDEXES DSN6SYSP DSNTIP2 Yes M IDXBPOOL
IGNSORTN IGNORE SORTNUM STMT DSN6SPRM DSNTIP6 Yes M IGNSORTN
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 Start of changeYesEnd of change M IRLMWAIT
IRLMSID SUBSYSTEM NAME DSN6SPRM DSNTIPI   U IRLMSSID
IXQTY INDEX SPACE ALLOCATION DSN6SYSP DSNTIP7 Yes G IXQTY
LBACKOUT LIMIT BACKOUT DSN6SYSP DSNTIPL1   M LBACKOUT
LC_CTYPE 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
Start of changeMAX_UDFEnd of change Start of changeMAX UDFSEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIPXEnd of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeMXUDF End of change
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
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 Start of change3End of change 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
Start of changeMXAIDTCACHEnd of change Start of changeMAX AI DATA CACHINGEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP81End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeMXAIDTCACHEnd of change
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
OPTHINTS OPTIMIZATION HINTS DSN6SPRM DSNTIP8 Yes M OPTHINTS
OTC_LICENSE OTC LICENSE USAGE DSN6SYSP DSNTIPO2   — OTC_LICENSE
OUTBUFF OUTPUT BUFFER DSN6LOGP DSNTIPL   M OUTBUFF
Start of changePACKAGE_DEPENDENCY_LEVELEnd of change Start of changePACKAGE DEPENDENCY LEVELEnd of change Start of changeDSN6PRMEnd of change Start of changeDSNTIP4End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changePKGDPLVEnd of change
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
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
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_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 Start of changeNoEnd of change 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
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 3 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 Start of changeYesEnd of change 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 3 G SECADM1
SECADM1_INPUT_STYLE — DSN6SPRM — Yes G SECA1IS
SECADM1_TYPE SEC ADMIN 1 TYPE DSN6SPRM DSNTIPP1 Yes 3 G SECAMD1T
SECADM2 SECURITY ADMIN 2 DSN6SPRM DSNTIPP1 Yes 3 G SECADMN2
SECADM2_INPUT_STYLE — DSN6SPRM — Yes G SECA2IS
SECADM2_TYPE SEC ADMIN 2 TYPE DSN6SPRM DSNTIPP1 Yes 3 G SECADM2T
SECQTY SECONDARY QTY DSN6ARVP DSNTIPA Yes M ARCHSEC
SEPARATE_SECURITY SEPARATE SECURITY DSN6SPRM DSNTIPP1 Yes 3 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
Start of changeSPREG_LOCK_TIMEOUT_MAXEnd of change Start of changeLOCK TIMEOUT MAXEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIPIEnd of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeLTMXEnd of change
SQLDELI SQL STRING DELIMITER DSNHDECP DSNTIPF   G DEFSQSTR
SQLLEVEL PRECOMPILER SQL LEVEL DSNHDECP DSNTIP00 Yes 5 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
Start of changeSTATIME_DDFEnd of change Start of changeDDF STATS TIMEEnd of change Start of changeDSN6SYSPEnd of change Start of changeDSNTIPNEnd of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeOPSTATMDEnd of change
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
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 3 G PROTADMN
SYSADM2 SYSTEM ADMIN 2 DSN6SPRM DSNTIPP1 Yes 3 G PROTADM2
SYSOPR1 SYSTEM OPERATOR 1 DSN6SPRM DSNTIPP1 Yes 3 G PROTOPR1
SYSOPR2 SYSTEM OPERATOR 2 DSN6SPRM DSNTIPP1 Yes 3 G PROTOPR2
SYSTEM_LEVEL_BACKUPS SYSTEM-LEVEL BACKUPS DSN6SPRM DSNTIP62 DSNTIP6 Yes M SYSLVLBK
Start of changeTABLE_COL_NAME_EXPANSIONEnd of change Start of change—End of change Start of changeDSN6SPRMEnd of change Start of change—End of change Start of changeYesEnd of change Start of changeREnd of change Start of changeTCNEEnd of change
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 3 G TCPALVER
TCPKPALV TCP/IP KEEPALIVE DSN6FAC DSNTIP5 Yes 3 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
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_MODIFY_REC_DELETEDS MODIFY RECOVERY - DELETEDS DSN6SPRM DSNTIP64 Yes G UMRDD
UTIL_TEMP_STORCLAS UTIL TEMP STORCLAS DSN6SPRM DSNTIP6 modify 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
Start of changeUTILITY_HISTORYEnd of change Start of changeUTILITY HISTORYEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeUTHISTEnd of change
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 —
Start of change—End of change Start of changeDATABASE AND TABLESPACE STORAGE GROUPEnd of change Start of change—End of change Start of changeDSNTIG1End of change Start of change End of change Start of change—End of change
— DBRM LIBRARY — DSNTIPT   M DSNDBRM
— DB2 administrator routines (DSNTIPRL) — DSNTIPRA   — —
— DB2 BASE JAVA DIR — DSNTIPX1   G DB2BASE
— 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)   — —
Start of change—End of change Start of changeGRANT OPTIONEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIPG End of change Start of change End of change Start of changeGEnd of change Start of changeGRANTOPTEnd of change
— GROUP ATTACH — DSNTIPK   G GRPATTNM
— HIGH LEVEL ASSEMBLER LIB — DSNTIPU   M ASMLIB
Start of change—End of change Start of changeHIGHEST ACTIVATED FUNCTION LEVELEnd of change Start of change—End of change Start of changeDSNTIP00: Activate a function level panelEnd of change Start of change End of change Start of changeGEnd of change Start of change—End of change
— 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
Start of change—End of change Start of changeINDEX SPACE STORAGE GROUPEnd of change Start of change—End of change Start of changeDSNTIG1End of change Start of change End of change Start of change—End of change
— INIT JAVA HEAP SIZE — DSNTIPX1   G JVMHEAP
— 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
— Start of changeJAVA CLASSESEnd of change — DSNTIPX1   G CLASPATH
— Start of changeJAVA RUNTIMEEnd of change — DSNTIPX1   G LIBPATH
— Java and SQL procedure processing routines (DSNITPRF) — DSNTIPRA   G IVPSQLID
— JAVA ENV DATA SET — DSNTIPX1   G JAVAENV
— JAVA ENV VAR FILE — DSNTIPX1   G JAVAENVV
— JDBC AND SQLJ DLLS — DSNTIPT   M DSNLOD2
— JDBC/SQLJ ENV VAR DIR — DSNTIPX1   G JCCHOME
— JDBC/SQLJ INSTALL ID — DSNTIPX1   G JCCSID
— JSON routines (DSNTIPRQ) — DSNTIPRA   — —
— JVM ADDRESSING MODE — DSNTIPX1   G JVMAMODE
— JVM PROPERTIES FILE — DSNTIPX1   G JVMPROPS
— 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 JVMAPPH
— MAX LOCK STORAGE UNIT — DSNTIPJ   M —
— MAX STORAGE FOR LOCKS — DSNTIPJ   M —
Start of change—End of change Start of changeMQ ADMIN ID(S)End of change Start of change—End of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeJRTMQADMEnd of change
— 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
Start of change—End of change Start of changePKG APPLCOMPATEnd of change Start of change—End of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeJRPMGTEnd of change
Start of change—End of change Start of changePKG PLANMGMTEnd of change Start of change—End of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeJRTAPCOEnd of change
— 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 — DSNTIPR: Distributed data facility panel 1   U RESYNPRT
— ROUTINES CREATOR — DSNTIPG   G AUTHID
— SAMPLE LIBRARY — DSNTIPT   M NEWSAMP
— Start of changeSDK HOME DIREnd of change — DSNTIPX1   G JAVAHOME
— SECURE PORT — DSNTIPR: Distributed data facility panel 1   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   — —
— 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

  1. 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 .
  2. 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.
  3. You must use a process with a privilege set that includes installation SYSADM authority or SECADM authority. For more information, see Security parameters.
  4. This subsystem parameter can only be changed online. Restarting Db2 has no effect on the setting.
  5. 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.