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 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  
Start of changeALLOW_UPD_DEL_INS_WITH_UREnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeAUDIWUEnd of change
Start of changeALTERNATE_CPEnd of change Start of changeALTERNATE COPY POOL End of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP62 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeBSACPEnd of change
AMCCSID ASCII CCSID DSNHDECP DSNTIPF   G AMCCSID
APPENSCH APPLICATION ENCODING DSNHDECP DSNTIPF   G APPENSCH
APPLCOMPAT APPL COMPAT LEVEL DSN6SPRM Start of changeDSNTIP00End of change 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
AUTHCACH PLAN AUTH CACHE DSN6SPRM DSNTIPP Yes 3 M AUTHCACH
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
Start of changeCACHEDYN_STABILIZATIONEnd of change Start of changeCACHE DYN STABILITYEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP8 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeCDSTEnd of change
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
Start of changeCDDS_MODEEnd of change Start of changeEnd of change Start of changeDSN6LOGPEnd of change Start of changeEnd of change Start of change End of change Start of changeGEnd of change Start of changeCDDSMODEnd of change
Start of changeCDDS_PREFIXEnd of change Start of changeEnd of change Start of changeDSN6LOGPEnd of change Start of changeEnd of change Start of change End of change Start of changeGEnd of change Start of changeCDDSPFXEnd of change
CDSSRDEF CURRENT DEGREE DSN6SPRM DSNTIP81 DSNTIP8 Yes M CDSSRDEF
Start of changeCHECK_FASTREPLICATIONEnd of change Start of changeFAST REPLICATION End of change Start of changeDSN6SPRMEnd of change Start of change End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeCHKFASRPEnd of change
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 Start of changeEnd of change   M CMTSTAT
Start of changeCOMCRITEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeStart of changeYesEnd of changeEnd of change Start of changeMEnd of change Start of changeStart of changeCOMCRITEnd of changeEnd of change
COMPACT COMPACT DATA DSN6ARVP DSNTIPA Yes M ARCHCOMP
Start of changeCOMPRESS_DIRLOBEnd of change Start of changeCOMPRESS DB2 DIR LOBSEnd of change Start of changeDSN6SPRMEnd of change Start of change DSNTIPA2 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeCDRLEnd of change
CONDBAT MAX REMOTE CONNECTED DSN6SYSP DSTIPE Yes M CONDBAT
Start of changeCOPY_FASTREPLICATIONEnd of change Start of changeCOPY FAST REPLICATIONEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP61 End of change Start of changeYesEnd of change Start of changeREnd of change Start of changeCYFREnd of change
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
DDF_COMPATIBILITY DSN6FAC Yes M DDFCMPAT
Start of changeDDL_MATERIALIZATIONEnd of change Start of changeDDL MATERIALIZATION End of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP71 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeDDLMEnd of change
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
Start of changeDEFAULT_INSERT_ALGORITHMEnd of change Start of changeDEFAULT INSERT ALGORITHMEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP71 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeDINAEnd of change
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
Start of changeDISALLOW_SSARAUTHEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYes 3End of change Start of changeMEnd of change Start of changeDSSAREnd of change
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
Start of changeENCRYPTION_KEYLABELEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYes 3, 4End of change Start of changeGEnd of change Start of changeENKLEnd of change
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 Start of changeEnd of change 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
Start of changeFLASHCOPY_XRCPEnd of change Start of changeFLASHCOPY XRCPEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP61End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeEnd of change
Start of changeFTB_NON_UNIQUE_INDEXEnd of change Start of changeFTB NON UNIQUE INDEXEnd of change Start of change End of change Start of changeDSNTIP71End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeFTBUOEnd of change
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 Start of changeEnd of change Yes M IDTHTOIN
IDXBPOOL DEFAULT BUFFER POOL FOR USER INDEXES DSN6SYSP Start of changeDSNTIP2End of change Yes M IDXBPOOL
IGNSORTN IGNORE SORTNUM STMT DSN6SPRM DSNTIP6 Yes M IGNSORTN
IMMEDWRI IMMEDIATE WRITE DSN6GRP DSNTIP8 Yes IMMEDWRI
IMPDSDEF DEFINE DATA SETS DSN6SYSP Start of changeDSNTIP72End of change 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 Start of changeDSNTIP72End of change Yes M IMPTSCMP
INDEX_CLEANUP_THREADS INDEX CLEANUP THREADS DSN6SPRM DSNTIPE1 Yes M IXCU
Start of changeINDEX_MEMORY_CONTROLEnd of change Start of changeINDEX MEMORY CONTROLEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP71End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeIXMCEnd of change
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 Start of changeDSNTIP72End of change 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
Start of changeLA_SINGLESEL_ISOCS_CDY End of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeLSSICEnd of change
Start of changeLIKE_BLANK_INSIGNIFICANTEnd of change Start of change Start of changeEnd of change End of change Start of changeDSN6SPRMEnd of change Start of change Start of changeEnd of change End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeLBINEnd of change
Start of changeLOAD_DEL_IMPLICIT_SCALEEnd of change Start of changeLOAD FORMAT DELIMITED IMPLICIT DECIMAL SCALEEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeLDISCALEEnd of change
Start of changeLOAD RO OBJECTSEnd of change Start of changeLOAD RO OBJECTSEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP6End of change Start of change End of change Start of changeMEnd of change Start of changeLIROEnd of change
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
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 Start of changeEnd of change Yes MAXTYPE1
MCCSID EBCDIC CCSID DSNHDECP DSNTIPF   G MCCSID
MEMBNAME MEMBER NAME DSN6GRP DSNTIPK   U MEMBNAME
Start of changeMFA_AUTHCACHE_UNUSED_TIMEEnd of change Start of changeMFA AUTH UNUSED TIMEEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIPP: Protection panel End of change Start of changeYes Start of change3End of changeEnd of change Start of changeGEnd of change Start of changeMFATEnd of change
Start of changeMINDVSCLEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYesEnd of change Start of changeEnd of change Start of changeMINDVSCLEnd of change
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
Start of changeOFFLOADEnd of change Start of changeEnd of change Start of changeDSN6LOGPEnd of change Start of changeEnd of change Start of changeNoEnd of change Start of changeMEnd of change Start of changeOFFLOADEnd of change
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 Start of changeDSNTIP71End of change Yes G PADIX
PADNTSTR PAD NUL-TERMINATED DSNHDECP DSNTIP4   M PADNSTSR
Start of changePAGESET_PAGENUMEnd of change Start of changePAGE SET PAGE NUMBERINGEnd of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP71 End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changePSPNEnd of change
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
Start of changePEER_RECOVERYEnd of change Start of changePEER RECOVERYEnd of change Start of changeDSN6GRPEnd of change Start of change DSNTIPK End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changePEERRRECOEnd of change
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 Start of changeDSNTIP72End of change Yes G PALK
PREVENT_NEW_IXCTRL_PART DSN6SPRM Yes G PCIP
PRIVATE_PROTOCOL DSN6FAC Yes G PRIVPRTL
Start of changePROFILE_AUTOSTARTEnd of change Start of changePROFILE AUTOSTARTEnd of change Start of changeDSN6SYSPEnd of change Start of changeDSNTIPO End of change Start of change End of change Start of changeMEnd of change Start of changePFASEnd of change
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
Start of changeQUERY_ACCEL_WAITFORDATAEnd of change Start of change WAIT FOR DATA End of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP82 End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeQAWFDEnd of change
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
Start of changeREMOTE_COPY_SW_ACCELEnd of change Start of changeREMOTE COPY SW ACCELEnd of change Start of changeDSN6LOGPEnd of change Start of change DSNTIPL End of change Start of changeYesEnd of change Start of changeREnd of change Start of changeRCSAEnd of change
RENAMETABLE RENAME TABLE DSN6SPRM Start of changeDSNTIP72End of change Yes G ERTS
REORG_DROP_PBG_PARTS REORG DROP PBG PARTS DSN6SPRM Start of changeDSNTIP63End of change Yes M RPBG
Start of changeREORG_IC_LIMIT_DASDEnd of change Start of changeREORG IC LIMIT DASDEnd of change Start of changeDSNSPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeRICLDEnd of change
Start of changeREORG_IC_LIMIT_TAPEEnd of change Start of changeREORG IC LIMIT TAPEEnd of change Start of changeDSNSPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeRICLTEnd of change
Start of changeREORG_INDEX_NOSYSUT1End of change Start of changeREORG INDEX NOSYSUT1End of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeRINSUEnd of change
REORG_LIST_PROCESSING REORG LIST PROCESSING DSN6SPRM Start of changeDSNTIP63End of change Yes M RLPR
REORG_MAPPING_DATABASE REORG MAPPING DB DSN6SPRM Start of changeDSNTIP6End of change Yes M RMDB
REORG_PART_SORT_NPSI REORG PART SORT NPSI DSN6SPRM Start of changeDSNTIP63End of change 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
Start of changeREORG_TS_NOPAD_DEFAULT End of change Start of changeREORG TS NOPAD DEFAULTEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP62End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeREONOPADEnd of change
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
Start of changeRETRY_STOPPED_OBJECTEnd of change Start of change RETRY STOPPED OBJECTS End of change Start of changeDSN6SPRMEnd of change Start of change DSTIP72 End of change Start of change End of change Start of changeGEnd of change Start of changeRSOEnd of change
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 Start of change DSNTIPO4 End of change   M RLFSTART
Start of changeRLFENABLEEnd of change Start of changeRLF SCOPE End of change Start of changeDSN6SYSPEnd of change Start of changeDSNTIPO4 End of change Start of changeStart of changeYesEnd of changeEnd of change Start of changeREnd of change Start of changeRLFSCOPEEnd of change
RLFAUTH RESOURCE AUTHID DSN6SYSP DSNTIPP1 Yes M PROTRLF
RLFERR Start of changeDYNAMIC SQLEnd of change DSN6SYSP Start of changeDSNTIPO4End of change Yes M RLFERROR
RLFERRD Start of changeREMOTE DYNAMIC SQLEnd of change DSN6FAC Start of changeDSNTIPO4End of change Yes M RLFERRD
Start of changeRLFERRSTCEnd of change Start of changeSTATIC SQL End of change Start of changeStart of changeDSN6SYSPEnd of changeEnd of change Start of change DSNTIPO4 End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeRLFERRSTEnd of change
Start of changeRLFERRDSTCEnd of change Start of changeREMOTE STATIC SQL End of change Start of changeDSN6FACEnd of change Start of change DSNTIPO4 End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeRLFERRSTEnd of change
RLFTBL RLST NAME SUFFIX DSN6SYSP Start of changeDSNTIPO4End of change 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
SQLDELI SQL STRING DELIMITER DSNHDECP DSNTIPF   G DEFSQSTR
Start of changeSQLLEVELEnd of change Start of changePRECOMPILER SQL LEVELEnd of change Start of changeDSNHDECPEnd of change Start of changeStart of changeDSNTIP00End of changeEnd of change Start of changeStart of changeYes Start of change5End of changeEnd of changeEnd of change Start of changeGEnd of change Start of changeStart of changeSQLLEnd of changeEnd of change
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
Start of changeSTATCLGSRTEnd of change Start of changeSTATISTICS COLGROUP DATA SORTEnd of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP6 End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeSTCSEnd of change
Start of changeSTATFDBK_PROFILEEnd of change Start of changeStart of changeSTATISTICS PROFILE FEEDBACKEnd of changeEnd of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP8 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeSFPREnd of change
STATFDBK_SCOPE Start of changeSTATISTICS FEEDBACKEnd of change DSN6SPRM Start of change DSNTIP8 End of change 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
Start of changeSTATIME_MAINEnd of change Start of changeMAIN STATS TIMEEnd of change Start of changeDSN6SYSPEnd of change Start of change DSNTIPN End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeOPSTATMMEnd of change
Start of changeSTATPGSAMPEnd of change Start of changePAGE-LEVEL SAMPLINGEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP6End of change Start of changeNoEnd of change Start of changeMEnd of change Start of changeSTPGSAMEnd of change
STATROLL STATISTICS ROLLUP DSN6SPRM DSNTIP6 Yes G STATROLL
STATSINT REAL TIME STATS DSN6SPRM Start of changeDSNTIP8End of change 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
Start of changeSUBSTR_COMPATIBILITYEnd of change Start of changeSUBSTR COMPATIBILITYEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIPXEnd of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeSUBSTRCPEnd of change
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
TBSBP8K DEFAULT 8-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes M TBSBP8K
TBSBP16K DEFAULT 16-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes M TBSBP16K
TBSBP32K DEFAULT 32-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes M TBSBP32K
TBSBPLOB DEFAULT BUFFER POOL FOR USER LOB DATA DSN6SYSP Start of changeDSNTIP2End of change Yes M TBSBPLOB
TBSBPOOL DEFAULT 4-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes M TBSBPOOL
TBSBPXML DEFAULT BUFFER POOL FOR USER XML DATA DSN6SYSP Start of changeDSNTIP2End of change 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
TRACSTR TRACE AUTO START DSN6SYSP DSNTIPN   M OPTRCAUT
TRACTBL TRACE SIZE DSN6SYSP DSNTIPN   M CALC/OPTRCSIZ
TRKRSITE TRACKER SITE DSN6SPRM DSNTIPO   G TRKRSITE
Start of changeTS_COMPRESSION_TYPEEnd of change Start of changeTS COMPRESSION TYPEEnd of change Start of changeStart of changeDSN6SPRMEnd of changeEnd of change Start of change DSNTIP7 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of change--End of change
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
Start of changeUTIL_DBBSGEnd of change Start of changeDB BACKUP STG GROUPEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP62 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeUDBSGEnd of change
Start of changeUTIL_LGBSGEnd of change Start of changeLOG BACKUP STG GRPEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP62 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeULBSGEnd of change
UTIL_TEMP_STORCLAS UTIL TEMP STORCLAS DSN6SPRM DSNTIP6 Yes G UTTEMPSC
Start of changeUTILS_HSM_MSGDS_HLQEnd of change Start of changeHSM MESSAGE DS HLQEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP62 End of change Start of changeYesEnd of change Start of changeGEnd of change Start of changeUHMDHEnd of change
Start of changeUTILS_BLOCK_FOR_CDCEnd of change Start of changeUTILS BLOCK FOR CDCEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP6End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeUBCDCEnd of change
UTILS_DUMP_CLASS_NAME DUMP CLASS NAME DSN6SPRM DSNTIP62 DSNTIP61 Yes M UTDUMPCL
Start of changeUTILS_USE_ZSORTEnd of change Start of changeUTILS USE ZSORTEnd of change Start of changeDSN6SPRMEnd of change Start of changeDSNTIP63End of change Start of changeYesEnd of change Start of changeMEnd of change Start of changeUZSORTEnd 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
Start of changeBP0 - BP49End of change DSNTIP1   M BP0 - BP29
Start of changeBP8K0 - BP32K9End of change 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
Start of changeEnd of change Start of changeC LE PRELINKER PHASEEnd of change Start of changeEnd of change Start of changeDSNTIPUEnd of change Start of change End of change Start of changeMEnd of change Start of changeEnd of change
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
Start of changeEnd of change Start of changeCPP LE PRELINKER PHASEEnd of change Start of changeEnd of change Start of changeDSNTIPUEnd of change Start of change End of change Start of changeMEnd of change Start of changeEnd of change
CPP PROCEDURE LIBRARY DSNTIPU   M CPPPROC
Start of changeEnd of change Start of changeCURRENT FUNCTION LEVELEnd of change Start of changeEnd of change Start of changeDSNTIP00End of change Start of change End of change Start of changeEnd of change Start of change End of change
DATA SET NAME PREFIX DSNTIPA1   DSNILIBP
DATA SET NAME SUFFIX DSNTIPA1   DSNILIBS
Start of changeEnd of change Start of changeDATA SET OR LIBRARY QUALIFIEREnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeGEnd of change Start of changeAGNEWIDSEnd of change
DATABASES DSNTIPD   M
Database metadata routines (DSNTIPRK) DSNTIPRA  
DATABASES DSNTIPE   M
Start of changeEnd of change Start of changeDATABASE AND TABLESPACE STORAGE GROUPEnd of change Start of changeEnd of change Start of changeDSNTIG1End of change Start of change End of change Start of changeEnd of change
DBRM LIBRARY DSNTIPT   M DSNDBRM
DB2 administrator routines (DSNTIPRL) DSNTIPRA  
DB2 BASE JAVA DIR DSNTIPX1   G DB2BASE
Start of changeEnd of change Start of changeDB2 COMMAND PREFIX FIRST CHARACTEREnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeGEnd of change Start of changeAGSSIDPXEnd of change
DB2 GENERIC LUNAME DSNTIPR   G GENLUNM
Start of changeEnd of change Start of changeStart of changeTARGET FUNCTION LEVELEnd of changeEnd of change Start of changeEnd of change Start of changeDSNTIP00End of change Start of change End of change Start of changeEnd of change Start of changeFUNCLVLEnd of change
DB2 LOCATION NAME DSNTIPR   G DDLOC
DB2 optimization routines (DSNTIPRM) DSNTIPRA  
DB2 security routines (DSNTIPRE) DSNTIPRA  
Start of changeEnd of change Start of changeDB2 TCP/IP IPNAMEEnd of change Start of changeEnd of change Start of changeDSNTIPREnd of change Start of change End of change Start of changeGEnd of change Start of changeIPNAMEEnd of change
Start of changeEnd of change Start of changeDB2 VTAM® LUNAMEEnd of change Start of changeEnd of change Start of changeDSNTIPREnd of change Start of change End of change Start of changeMEnd of change Start of changeDDLUNAMEnd of change
Start of changeEnd of change Start of changeDB2 VTAM PASSWORDEnd of change Start of changeEnd of change Start of changeDSNTIPREnd of change Start of change End of change Start of changeMEnd of change Start of changeDDPASSEnd of change
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
Start of changeEnd of change Start of changeENGLISH TASK AND PANELS LIBRARYEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeMEnd of change Start of changeDSNPFPEEnd of change
Enter job card information for install and sample jobs DSBNTIPY   M
EXECUTED STMTS DSNTIPD   M NUMSTMTE
EXIT LIBRARY DSNTIPT   M DSNEXIT
Start of changeEnd of change Start of changeFAVOR NEW ACCELERATOR_TYPE End of change Start of changeEnd of change Start of change DSNTIP8A End of change Start of changeYesEnd of change Start of changeEnd of change Start of changeEnd of change
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
Start of changeEnd of change Start of changeIC DATA SET UNIT NAMEEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
Start of changeEnd of change Start of changeIC TEMPLATE DATA CLASSEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
Start of changeEnd of change Start of changeIC TEMPLATE EXPRESSIONEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
Start of changeEnd of change Start of changeIC TEMPLATE MGMT CLASSEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
Start of changeEnd of change Start of changeIC TEMPLATE STOR CLASSEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
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 changeEnd of change Start of changeINDEX SPACE STORAGE GROUPEnd of change Start of changeEnd of change Start of changeDSNTIG1End of change Start of change End of change Start of changeEnd 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 Start of changeDSNTIPG1End of change   M INSICPRE
INSTALL IRLM DSNTIPG   M
INSTALL DS PREFIX Start of changeDSNTIPG1End of change   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
Start of changeEnd of change Start of changeISPF COMMAND TABLE LIBRARYEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeMEnd of change Start of changeDSNSPFTEnd of change
Start of changeEnd of change Start of changeISPF INSTALL TASK AND PANELS LIBRARYEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeMEnd of change Start of changeDSNSPFPEnd of change
ISPF ISPLINK MODULE DSNTIPW   M ISPLOAD
Start of changeEnd of change Start of changeISPF MESSAGE LIBRARYEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeMEnd of change Start of changeDSNSPFMEnd of change
Start of changeEnd of change Start of changeISPF SKELETON LIBRARYEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeMEnd of change Start of changeDSNSPFSEnd of change
IVP DATA LIBRARY DSNTIPT   M DSNIVPD
Start of changeEnd of change Start of changeIVP GRANTEEEnd of change Start of changeEnd of change Start of changeDSNTIPGEnd of change Start of change End of change Start of changeMEnd of change Start of changeEnd of change
Start of changeEnd of change Start of changeIVP PKG OWNEREnd of change Start of changeEnd of change Start of changeDSNTIPGEnd of change Start of change End of change Start of changeMEnd of change Start of changeIVPGRLSTEnd of change
Start of changeEnd of change Start of changeIVP SQL IDEnd of change Start of changeEnd of change Start of changeDSNTIPGEnd of change Start of change End of change Start of changeGEnd of change Start of changeIVPPKOWNEnd of change
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 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
Start of changeEnd of change Start of changePKG APPLCOMPATEnd of change Start of changeEnd of change Start of changeDSNTIPG1End of change Start of change End of change Start of changeJRPMGTEnd of change
Start of changeEnd of change Start of changePKG PLANMGMTEnd of change Start of changeEnd 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
Start of changeEnd of change Start of changePL/I LE PRELINKER PHASE End of change Start of changeEnd of change Start of changeDSNTIPU1 End of change Start of change End of change Start of changeMEnd of change Start of changePLIPRLKEnd of change
Start of changeEnd of change Start of changePROVISION EXEC IDEnd of change Start of changeEnd of change Start of changeDSNTIPG: Installation preferences panelEnd of change Start of change End of change Start of changeGEnd of change Start of changeAGEXECIDEnd of change
REMOTE LOCATION DSNTIPY   M
RESYNC PORT Start of changeEnd of change   U RESYNPRT
ROUTINES CREATOR DSNTIPG   G AUTHID
SAMPLE LIBRARY DSNTIPT   M NEWSAMP
SECURE PORT Start of changeEnd of change   G SECPORT
SEC DEF CREATOR DSNTIPG   G SECDEFID
START IRLM CTRACE DSNTIPJ   M
Start of changeEnd of change Start of changeSOFTWARE SERVICE INSTANCE NAME PREFIXEnd of change Start of changeEnd of change Start of changeDSNTIPAPEnd of change Start of change End of change Start of changeGEnd of change Start of changeEnd of change
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
Start of changeEnd of change Start of changeTCP/IP PORTEnd of change Start of changeEnd of change Start of changeDSNTIPR: Distributed data facility panel 1 End of change Start of change End of change Start of changeGEnd of change Start of changeTCPPORTEnd of change
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 JAVAHOME
Z/OS USS JAVA CLASSES DSNTIPX1   G CLASPATH
Z/OS USS JAVA RUNTIME DSNTIPX1   G LIBPATH
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. Start of changeFor 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.End of change

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.