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 DSNTIDxx entry or z/OSMF variable 1
ABEXP EXPLAIN PROCESSING DSN6SPRM DSNTIPO Yes ABEXP
ABIND AUTO BIND DSN6SPRM DSNTIPO Yes ABIND
ACCEL ACCELERATION STARTUP DSN6SPRM DSNTIP82   ACCEL
ACCELMODEL DSN6SPRM Yes ACCELMODEL
ACCESS_CNTL_MODULE ACCESS CONTROL DSN6SYSP DSNTIPO3   ACCTLMOD
ACCUMACC DDF/RRSAF ACCUM DSN6SYSP DSNTIPN Yes ACCUMAC
ACCUMUID AGGREGATION FIELDS DSN6SYSP DSNTIPN Yes ACCUMUID
ADMTPROC ADMIN SCHEDULER DSN6SPRM DSNTIPX   ADMTPROC
AEXITLIM AUTH EXIT LIMIT DSN6SPRM DSNTIPP Yes AEXITLIM
AGCCSID ASCII CCSID DSNHDECP DSNTIPF   AGCCSID
dbnameALL/ 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 changeAUDIWUEnd of change
Start of changeALTERNATE_CPEnd of change Start of change ALTERNATE COPY POOL End of change Start of changeDSN6SPRMEnd of change Start of change DSNTIP62 End of change Start of changeYesEnd of change Start of changeBSACPEnd of change
AMCCSID ASCII CCSID DSNHDECP DSNTIPF   AMCCSID
APPENSCH APPLICATION ENCODING DSNHDECP DSNTIPF   APPENSCH
APPLCOMPAT APPL COMPAT LEVEL DSN6SPRM Start of changeDSNTIP00End of change Yes APPLCOMPAT
ARCPFX1 Archive logs: COPY 1 PREFIX DSN6ARVP DSNTIPH Yes ARCHPRE1
ARCPFX2 Archive logs: COPY 2 PREFIX DSN6ARVP DSNTIPH Yes ARCHPRE2
ARCRETN RETENTION PERIOD DSN6ARVP DSNTIPA Yes ARCRETN
ARCWRTC WTOR ROUTE CODE DSN6ARVP DSNTIPA Yes ARCHWRTC
ARCWTOR WRITE TO OPER DSN6ARVP DSNTIPA Yes ARCHWTOR
ARC2FRST READ COPY2 ARCHIVE DSN6LOGP DSNTIPO Yes ARC2FRST
ASCCSID ASCII CCSID DSNHDECP DSNTIPF   ASCCSIDE
AUDITST AUDIT TRACE DSN6SYSP DSNTIPN   AUDIT
AUTH USE PROTECTION DSN6SPRM DSNTIPP   PROAUTH
AUTHCACH PLAN AUTH CACHE DSN6SPRM DSNTIPP Yes2 AUTHCACH
AUTHEXIT_CACHEREFRESH AUTH EXIT CACHE REFR DSN6SPRM DSNTIPP   AECR
AUTH_COMPATIBILITY DSN6SPRM Yes AUTCMPAT
AUTHEXIT_CHECK AUTH EXIT CHECK DSN6SPRM DSNTIPP   RACK
BACKODUR BACKOUT DURATION DSN6SYSP DSNTIPL1   BACKODUR
BIF_COMPATIBILITY BIF COMPATIBILITY DSN6SPRM DSNTIPX Yes BIFCP
BINDNV BIND NEW PACKAGE DSN6SPRM DSNTIPP1 Yes2 BINDNV
BLKSIZE BLOCK SIZE DSN6ARVP DSNTIPA Yes ARCHSIZE
BMPTOUT IMS BMP TIMEOUT DSN6SPRM DSNTIPI Yes BMPTOUT
CACHEDYN CACHE DYNAMIC SQL DSN6SPRM DSNTIP8 Yes 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 changeCDSTEnd of change
CATALOG CATALOG ALIAS DSN6SPRM DSNTIPA2   VCATALOG
CATDDACL DIRECTORY AND CATALOG DATA DSN6SPRM DSNTIPA2 Yes CATDDACL
CATDMGCL DIRECTORY AND CATALOG DATA DSN6SPRM DSNTIPA2 Yes CATDMGCL
CATDSTCL DIRECTORY AND CATALOG DATA DSN6SPRM DSNTIPA2 Yes CATDSTCL
CATXDACL DIRECTORY AND CATALOG INDEXES DSN6SPRM DSNTIPA2 Yes CATXDACL
CATXMGCL DIRECTORY AND CATALOG INDEXES DSN6SPRM DSNTIPA2 Yes CATXMGCL
CATXSTCL DIRECTORY AND CATALOG INDEXES DSN6SPRM DSNTIPA2 Yes 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 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 changeCDDSPFXEnd of change
CDSSRDEF CURRENT DEGREE DSN6SPRM DSNTIP81 DSNTIP8 Yes 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 changeCHKFASRPEnd of change
CHKFREQ CHECKPOINT FREQ DSN6SYSP DSNTIPL1 Yes CHKFREQ
CHKLOGR RECORDS/CHECKPOINT DSN6SYSP DSNTIPL1 Yes CHKLOGR
CHKMINS MINUTES/CHECKPOINT DSN6SYSP DSNTIPL1 Yes CKPTTIME
CHKTYPE CHECKPOINT TYPE DSN6SYSP DSNTIPL1 Yes CHKTYPE
CMTSTAT DDF THREADS DSN6FAC Start of changeEnd of change   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 changeStart of changeCOMCRITEnd of changeEnd of change
COMPACT COMPACT DATA DSN6ARVP DSNTIPA Yes 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 changeCDRLEnd of change
CONDBAT MAX REMOTE CONNECTED DSN6SYSP DSTIPE Yes 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 changeCYFREnd of change
CTHREAD MAX USERS DSN6SYSP DSNTIPE Yes NUMCONCR
DBACRVW DBADM CREATE AUTH DSN6SPRM DSNITPP1 Yes2 DBACRVW
DATE DATE FORMAT DSNHDECP DSNTIP4   DEFDATE
DATELEN LOCAL DATE LENGTH DSNHDECP DSNITP4   DEFDATEL
DB2SUPLD DSNHDECP   DB2SUPLD
DDF DDF STARTUP OPTION DSN6FAC DSNTIPR   DDSTART
DDF_COMPATIBILITY DSN6FAC Yes 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 changeDDLMEnd of change
DDLTOX DATA DEF TIMEOUT DSN6SPRM DSNTIPE1 Yes DDLTOX
DEALLCT DEALLOC PERIOD DSN6LOGP DSNTIPA Yes ARCHDEAP
DECARTH DECIMAL ARITHMETIC DSNHDECP DSNTIP4   DECARTH
DECDIV3 MINIMUM DIVIDE SCALE DSN6SPRM DSNTIP4   DECDIV3
DECIMAL DECIMAL POINT IS DSNHDECP DSNTIPF   DECPOINT
DEF_DECFLOAT_ROUND_MODE DECFLOAT ROUNDING MODE DSNHDECP DSNTIPF   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 changeDINAEnd of change
DEFLANG LANGUAGE DEFAULT DSNHDECP DSNTIPF   DEFLANG
DEFLTID UNKNOWN AUTHID DSN6SPRM DSNTIPP1   PROTUNKN
DEL_CFSTRUCTS_ON_RESTART DEL CF STRUCTS DSN6SYSP DSNTIPK   DCFS
DELIM STRING DELIMITER DSNHDECP DSNTIPF   DEFSTRNG
DESCSTAT DESCRIBE FOR STATIC DSN6SPRM DSNTIP4 Yes DECSTAT
DISABLE_EDMRTS DISABLE EDM RTS DSN6SPRM DSNTIP8 Yes DEDR
DISALLOW_SEL_INTO_UNION DSN6SPRM Yes
Start of changeDISALLOW_SSARAUTHEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYesEnd of change Start of changeDSSAREnd of change
DLDFREQ LEVELID UPDATE FREQ DSN6SYSP DSNTIPL1 Yes DLDFREQ
DLITOUT DL/I BATCH TIMEOUT DSN6SPRM DSNTIPI Yes DLITOUT
DPSEGSZ DEFAULT PARTITION SEGSIZE DSN6SYSP DSNTIP71 Yes DPSEGSZ
DSHARE DATA SHARING DSN6GRP DSNTIPA1   DSHARE
DSMAX DSMAX DSN6SPRM DSNTIPC Yes OPNDS
DSQLDELI DIST SQL STR DELIMTR DSNHDECP DSNTIPF   DECPDSSD
DSSTIME DATASET STATS TIME DSN6SYSP DSNTIPN Yes DSSTIME
DSVCI VARY DS CONTROL INTERVAL DSN6SYSP DSNTIP7 Yes DSVCI
DYNRULS USE FOR DYNAMICRULES DSNHDECP DSNTIP4   DYNRULS
EDM_SKELETON_POOL EDM SKELETON POOL SIZE DSN6SPRM DSNTIPC Yes EDMSKP
EDMDBDC EDM DBD CACHE DSN6SPRM DSNTIPC Yes EDMDBDC
EDMSTMTC EDM STATEMENT CACHE DSN6SPRM DSNTIPC Yes EDMSTMTC
EN_PJSJ DSN6SPRM Yes ENSHCEME
Start of changeENCRYPTION_KEYLABELEnd of change Start of changeEnd of change Start of changeDSN6SPRMEnd of change Start of changeEnd of change Start of changeYes3End of change Start of changeENKLEnd of change
ENSCHEME DEF ENCODING SCHEME DSNHDECP DSNTIPF   ENPJSJ
EVALUNC EVALUATE UNCOMMITTED DSN6SPRM DSNTIP8 Yes 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 Yes2 EXTSEC
FCCOPYDDN DEFAULT TEMPLATE DSN6SPRM DSNTIP61 Yes FCCDTEMP
FLASHCOPY_COPY COPY DSN6SPRM DSNTIP61 Yes FCCP
FLASHCOPY_LOAD LOAD DSN6SPRM DSNTIP61 Yes FCLP
FLASHCOPY_PPRC FLASHCOPY PPRC DSN6SPRM DSNTIP61 Yes FCPPRC
FLASHCOPY_REBUILD_INDEX REBUILD INDEX DSN6SPRM DSNTIP61 Yes FCROT
FLASHCOPY_REORG_INDEX REORG INDEX DSN6SPRM DSNTIP61 Yes FCRBI
FLASHCOPY_REORG_TS REORG TABLESPACE DSN6SPRM DSNTIP61 Yes 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 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 changeFTBUOEnd of change
GCCSID EBCDIC CCSID DSNHDECP DSNTIPF   GCCSID
GET_ACCEL_ARCHIVE GET ACCEL ARCHIVE DSN6SPRM DSNTIP82 Yes CGAA
GRPNAME GROUP NAME DSN6GRP DSNTIPK   GRPNAME
HONOR_KEEPDICTIONARY DSN6SPRM Yes HNRKPDIC
IDAUTH_MODULE IDENTIFY/AUTH DSN6SYSP DSNTIPO3   IDAUTMOD
IDBACK MAX BATCH CONNECT DSN6SYSP DSNTIPE Yes NUMCONBT
IDFORE MAX TSO CONNECT DSN6SYSP DSNTIPE Yes NUMCONTS
IDTHTOIN IDLE THREAD TIMEOUT DSN6FAC Start of changeEnd of change Yes IDTHTOIN
IDXBPOOL DEFAULT BUFFER POOL FOR USER INDEXES DSN6SYSP Start of changeDSNTIP2End of change Yes IDXBPOOL
IGNSORTN IGNORE SORTNUM STMT DSN6SPRM DSNTIP6 Yes IGNSORTN
IMMEDWRI IMMEDIATE WRITE DSN6GRP DSNTIP8 Yes IMMEDWRI
IMPDSDEF DEFINE DATA SETS DSN6SYSP Start of changeDSNTIP72End of change Yes IMPDSDEF
IMPDSSIZE DSN6SYSP Yes IMPDSIZE
IMPLICIT_TIMEZONE IMPLICIT TIME ZONE DSNHDECP DSNTIP4   IMTZ
IMPTKMOD DSN6SYSP Yes IMPTKMOD
IMPTSCMP USE DATA COMPRESSION DSN6SYSP Start of changeDSNTIP72End of change Yes IMPTSCMP
INDEX_CLEANUP_THREADS INDEX CLEANUP THREADS DSN6SPRM DSNTIPE1 Yes 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 changeIXMCEnd of change
INLISTP DSN6SPRM Yes INLISTP
IRLMPRC PROC NAME DSN6SPRM DSNTIPI   IRLMPROC
IRLMRWT RESOURCE TIMEOUT DSN6SPRM DSNTIPI   IRLMWAIT
IRLMSID SUBSYSTEM NAME DSN6SPRM DSNTIPI   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 IXQTY
LBACKOUT LIMIT BACKOUT DSN6SYSP DSNTIPL1   LBACKOUT
LC_TYPE LOCALE LC_CTYPE DSNHDECP DSNTIPF   LCCTYPE
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 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 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 changeLIROEnd of change
LOB_INLINE_LENGTH LOB INLINE LENGTH DSN6SYSP DSNTIPD Yes LOBINLEN
LRDRTHLD LONG-RUNNING READER DSN6SPRM DSNTIPE Yes LRDRTHLD
MAINTYPE CURRENT MAINT TYPES DSN6SPRM DSNTIP81 Yes MAINTYPE
MATERIALIZE_NODET_SQLTUDF DSN6SPRM Yes MNSU
MAXSORT_IN_MEMORY MAX IN-MEMORY SORT SIZE DSN6SPRM DSNTIPC Yes ARHCMAX
MAX_CONCURRENT_PKG_OPS DSN6SPRM Yes MXCONPKG
MAX_NUM_CUR MAX OPEN CURSORS DSN6SPRM DSNTIPX Yes MXNUMCUR
MAX_ST_PROC MAX STORED PROCS DSN6SPRM DSNTIPX Yes MXSTPROC
MAXARCH RECORDING MAX DSN6LOGP DSNTIPA   ARCHMAXV
MAXCONQN CONN QUEUE MAX DEPTH DSN6FAC DSNTIP5 Yes MAXCONQN
MAXCONQW CONN QUEUE MAX WAIT DSN6FAC DSNTIP5 Yes MAXCONQW
MAXDBAT MAX REMOTE ACTIVE DSN6SYSP DSNTIPE Yes NUMCONRM
MAXKEEPD MAX KEPT DYN STMTS DSN6SPRM DSNTIPE Yes MAXKEEPD
MAXOFILR MAX OPEN FILE REFS DSN6SYSP DSNTIPE Yes MAXOFILR
MAXRBLK RID POOL SIZE DSN6SPRM DSNTIPC Yes RIDPOOL
MAXRTU READ TAPE UNITS DSN6LOGP DSNTIPA Yes ARCHMRTU
MAXTEMPS MAX TEMP STG/AGENT DSN6SPRM DSNTIP91 Yes MAXTEMPS
MAXTEMPS_RID MAX TEMP RID DSN6SPRM DSNTIP91 Yes MXTMPRID
MAXTYPE1 MAX INACTIVE DBATS DSN6FAC Start of changeEnd of change Yes MAXTYPE1
MCCSID EBCDIC CCSID DSNHDECP DSNTIPF   MCCSID
MEMBNAME MEMBER NAME DSN6GRP DSNTIPK   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 changeYesEnd 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 changeMINDVSCLEnd of change
MIXED MIXED DATA DSNHDECP DSNTIPF   DEFMIXED
MON MONITOR TRACE DSN6SYSP DSNTIPN   MON
MONSIZE MONITOR SIZE DSN6SYSP DSNTIPN   MONSIZE
MOVE_TO_ARCHIVE_DEFAULT DSN6SPRM Yes MOVE_TO_ARCHIVE_DEFAULT
MXDTCACH MAX DATA CACHING DSN6SPRM DSNTIP81 Yes MXDCACH
NPGTHRSH DSN6SPRM Yes NPGTHRSH
NUMLKTS LOCKS PER TABLE(SPACE) DSN6SPRM DSNTIPJ Yes IRLMLKTS
NUMLKUS LOCKS PER USER DSN6SPRM DSNTIPJ Yes IRLMLKUS
OPT1ROWBLOCKSORT DSN6SPRM Yes OP1RBSRT
OPTHINTS OPTIMIZATION HINTS DSN6SPRM DSNTIP8 Yes OPTHINTS
OTC_LICENSE OTC LICENSE USAGE DSN6SYSP DSNTIPO2   OTC_LICENSE
OUTBUFF OUTPUT BUFFER DSN6LOGP DSNTIPL   OUTBUFF
PADIX PAD INDEXES BY DEFAULT DSN6SPRM Start of changeDSNTIP71End of change Yes PADIX
PADNTSTR PAD NUL-TERMINATED DSNHDECP DSNTIP4   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 changePSPNEnd of change
PARA_EFF PARALLELISM EFFICIENCY DSN6SPRM DSNTIP81 Yes PARAEFF
PARAMDEG MAX DEGREE DSN6SPRM DSNTIP81 Yes PARAMDEG
PARAMDEG_DPSI MAX DEGREE FOR DPSI DSN6SPRM DSNTIP81 Yes DEGD
PARAMDEG_UTIL MAX UTILS PARALLELISM DSN6SPRM DSNTIP6 Yes UMD
PCTFREE_UPD PERCENT FREE FOR UPDATE DSN6SPRM DSNTIP71 Yes PFUP
PCLOSET RO SWITCH TIME DSN6SYSP DSNTIPL1 Yes 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 changePEERRRECOEnd of change
PKGREL_COMMIT PACKAGE RELEASE COMMIT DSN6SPRM DSNTIP8 Yes PKRC
PLANMGMT PLAN MANAGEMENT DSN6SPRM DSNTIP8 Yes PLANMGMT
PLANMGMTSCOPE PLAN MANAGEMENT SCOPE DSN6SPRM DSNTIP8 Yes PMSCOPE
POOLINAC POOL THREAD TIMEOUT DSN6FAC DSNTIP5 Yes POOLINAC
PRIQTY PRIMARY QUANTITY DSN6ARVP DSNTIPA Yes ARCHPRI
PREVENT_ALTERTB_LIMITKEY PREVENT ALTER LIMITKEY DSN6SPRM Start of changeDSNTIP72End of change Yes PALK
Start of changePREVENT_NEW_IXCTRL_PARTEnd 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 changePCIPEnd of change
PRIVATE_PROTOCOL DSN6FAC Yes 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 changePFASEnd of change
PROTECT ARCHIVE LOG RACF DSN6ARVP DSNTIPP Yes PROTARAC
PTASKROL DSN6SYSP Yes PTASKROL
QUERY_ACCEL_OPTIONS ACCELERATION OPTIONS DSN6SPRM DSNTIP82 Yes QACO
QUERY_ACCELERATION CURRENT QUERY ACCEL DSN6SPRM DSNTIP82 Yes 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 changeQAWFDEnd of change
QUIESCE QUIESCE PERIOD DSN6ARVP DSNTIPA Yes ARCHMQP
RANDOMATT RANDOM ATTACH DSN6GRP DSNTIPK Yes RANDOMAT
REALSTORAGE_MANAGEMENT MANAGE REAL STORAGE DSN6SPRM DSNTIPE1 Yes RSMGMT
REALSTORAGE_MAX DSN6SPRM Yes RSMAX
REC_FASTREPLICATION FAST RESTORE DSN6SPRM DSNTIP61 Yes RECFASRP
RECALL RECALL DATABASE DSN6SPRM DSNTIPO   RECALL
RECALLD RECALL DELAY DSN6SPRM DSNTIPO Yes RECALLD
REFSHAGE CURRENT REFRESH AGE DSN6SPRM DSNTIP81 Yes 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 changeRCSAEnd of change
RENAMETABLE RENAME TABLE DSN6SPRM Start of changeDSNTIP72End of change Yes ERTS
REORG_DROP_PBG_PARTS REORG DROP PBG PARTS DSN6SPRM Start of changeDSNTIP63End of change Yes 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 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 changeRICLTEnd of change
Start of changeREORG INDEX NOSYSUT1 (REORG_INDEX_NOSYSUT1 subsystem parameter)End 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 changeRINSUEnd of change
REORG_LIST_PROCESSING REORG LIST PROCESSING DSN6SPRM Start of changeDSNTIP63End of change Yes RLPR
REORG_MAPPING_DATABASE REORG MAPPING DB DSN6SPRM Start of changeDSNTIP6End of change Yes RMDB
REORG_PART_SORT_NPSI REORG PART SORT NPSI DSN6SPRM Start of changeDSNTIP63End of change DSNTIP62 Yes RPSN
RESTART RESTART OR DEFER DSN6SPRM DSNTIPS   RESTART
RESTORE_RECOVER_FROMDUMP RESTORE/RECOVER DSN6SPRM DSNTIP62 Yes RESRECFD
RESTORE_TAPEUNITS MAXIMUM TAPE UNITS DSN6SPRM DSNTIP62 DSNTIP6 Yes 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 changeREONOPADEnd of change
RESTRICT_ALT_COL_FOR_DCC DSN6SPRM Yes RACFD
RESYNC RESYNC INTERVAL DSN6FAC DSNTIPR Yes RESYNC
RETLWAIT RETAINED LOCK TIMEOUT DSN6SPRM DSNTIPI Yes 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 changeRSOEnd of change
REVOKE_DEP_PRIVILEGES REVOKE DEP PRIV DSN6SPRM DSNTIPP1 Yes2 REVDPRIV
RGFCOLID REGISTRATION OWNER DSN6SPRM DSNTIPZ   RGFCOLID
RGFDBNAM REGISTRATION DATABASE DSN6SPRM DSNTIPZ   RGFDBNAM
RGFDEDPL CONTROL ALL APPLICATIONS DSN6SPRM DSNTIPZ   RGFDEDPL
RGFDEFLT UNREGISTERED DDL DEFAULT DSN6SPRM DSNTIPZ   RGFDEFLT
RGFESCP ART/ORT ESCAPE CHARACTER DSN6SPRM DSNTIPZ   RGFESCP
RGFFULLQ REQUIRE FULL NAMES DSN6SPRM DSNTIPZ   RGFFULLQ
RGFINSTL INSTALL DD CONTROL SUPT DSN6SPRM DSNTIPZ   RGFINSTL
RGFNMORT OBJT REGISTRATION TABLE DSN6SPRM DSNTIPZ   RGFNMORT
RGFNMPRT APPL REGISTRATION TABLE DSN6SPRM DSNTIPZ   RGFNMPRT
RLF RLF AUTO START DSN6SYSP Start of change DSNTIPO4 End of change   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 change End of change Start of changeRLFSCOPEEnd of change
RLFAUTH RESOURCE AUTHID DSN6SYSP DSNTIPP1 Yes PROTRLF
RLFERR Start of changeDYNAMIC SQLEnd of change DSN6SYSP Start of changeDSNTIPO4End of change Yes RLFERROR
RLFERRD Start of changeREMOTE DYNAMIC SQLEnd of change DSN6FAC Start of changeDSNTIPO4End of change Yes 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 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 changeRLFERRSTEnd of change
RLFTBL RLST NAME SUFFIX DSN6SYSP Start of changeDSNTIPO4End of change Yes RLFSUFF
ROUTCDE WTO ROUTE CODES DSN6SYSP DSNTIPO   OPROUTCD
RRULOCK U LOCK FOR RR/RS DSN6SPRM DSNTIPI Yes RRULOCK
SCCSID EBCDIC CCSID DSNHDECP DSNTIPF   SCCSID
SECADM1 SECURITY ADMIN 1 DSN6SPRM DSNTIPP1 Yes2 SECADM1
SECADM1_INPUT_STYLE DSN6SPRM Yes SECA1IS
SECADM1_TYPE SEC ADMIN 1 TYPE DSN6SPRM DSNTIPP1 Yes2 SECAMD1T
SECADM2 SECURITY ADMIN 2 DSN6SPRM DSNTIPP1 Yes2 SECADMN2
SECADM2_INPUT_STYLE DSN6SPRM Yes SECA2IS
SECADM2_TYPE SEC ADMIN 2 TYPE DSN6SPRM DSNTIPP1 Yes2 SECADM2T
SECQTY SECONDARY QTY DSN6ARVP DSNTIPA Yes ARCHSEC
SEPARATE_SECURITY SEPARATE SECURITY DSN6SPRM DSNTIPP1 Yes2 SEPSECUR
SIGNON_MODULE SIGNON DSN6SYSP DSNTIPO3   SIGNON
SIMULATED_CPU_COUNT DSN6SPRM Yes SIMCCNT
SIMULATED_CPU_SPEED DSN6SPRM Yes SIMCSPD
SITETYP SITE TYPE DSN6SPRM DSNTIPO   SITETYP
SJTABLES DSN6SPRM Yes SJTABLES
SKIPUNCI SKIP UNCOMM INSERTS DSN6SPRM DSNTIP8 Yes SKIPUNCI
SMF89 DSN6SYSP Yes SMF89
SMFACCT SMF ACCOUNTING DSN6SYSP DSNTIPN   OPSMFACT
SMFCOMP COMPRESS SMF RECS DSN6SYSP DSNTIPN Yes SMFCOMP
SMFSTAT SMF STATISTICS DSN6SYSP DSNTIPN   OPSMFSTA
SQLDELI SQL STRING DELIMITER DSNHDECP DSNTIPF   DEFSQSTR
Start of changeSQLLEVELEnd of change Start of changePRECOMPILER SQL LEVELEnd of change Start of changeDSNHDECPEnd of change Start of changeStart of changeDSNTIP00End of change End of change Start of changeStart of changeYesStart of change4End of changeEnd of changeEnd of change Start of changeStart of changeSQLLEnd of changeEnd of change
SRTPOOL SORT POOL SIZE DSN6SPRM DSNTIPC Yes SRTPOOL
SSID SUBSYSTEM NAME DSNHDECP DSNTIPM   MVSSNAME
STARJOIN STAR JOIN QUERIES DSN6SPRM DSNTIP81 Yes 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 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 changeSFPREnd of change
STATFDBK_SCOPE Start of changeSTATISTICS FEEDBACKEnd of change DSN6SPRM Start of change DSNTIP8 End of change Yes SFBS
STATHIST STATISTICS HISTORY DSN6SPRM DSNTIP6 DSNTIP61 Yes STATHIST
STATIME STATISTICS TIME DSN6SYSP DSNTIPN Yes OPSTATIM
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 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 changeSTPGSAMEnd of change
STATROLL STATISTICS ROLLUP DSN6SPRM DSNTIP6 Yes STATROLL
STATSINT REAL TIME STATS DSN6SPRM Start of changeDSNTIP8End of change Yes STATSINT
STDSQL STD SQL LANGUAGE DSNHDECP DSNTIP4   DEFSQLVL
STORMXAB MAX ABEND COUNT DSN6SYSP DSNTIPX Yes STORMXAB
STORTIME TIMEOUT VALUE DSN6SYSP DSNTIPX Yes 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 changeSUBSTRCPEnd of change
SUPERRS SUPPRESS SOFT ERRORS DSN6SPRM DSNTIPM Yes SUPERRS
SUPPRESS_HINT_SQLCODE_DYN DSN6SPRM Yes SHSD
SVOLARC SINGLE VOLUME DSN6ARVP DSNTIPA Yes SVOLARC
SYNCVAL STATISTICS SYNC DSN6SYSP DSNTIPN Yes SYNCVAL
SYSADM SYSTEM ADMIN 1 DSN6SPRM DSNTIPP1 Yes2 PROTADMN
SYSADM2 SYSTEM ADMIN 2 DSN6SPRM DSNTIPP1 Yes2 PROTADM2
SYSOPR1 SYSTEM OPERATOR 1 DSN6SPRM DSNTIPP1 Yes2 PROTOPR1
SYSOPR2 SYSTEM OPERATOR 2 DSN6SPRM DSNTIPP1 Yes2 PROTOPR2
SYSTEM_LEVEL_BACKUPS SYSTEM-LEVEL BACKUPS DSN6SPRM DSNTIP62 DSNTIP6 Yes SYSLVLBK
TBSBP8K DEFAULT 8-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBP8K
TBSBP16K DEFAULT 16-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBP16K
TBSBP32K DEFAULT 32-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBP32K
TBSBPLOB DEFAULT BUFFER POOL FOR USER LOB DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBPLOB
TBSBPOOL DEFAULT 4-KB BUFFER POOL FOR USER DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBPOOL
TBSBPXML DEFAULT BUFFER POOL FOR USER XML DATA DSN6SYSP Start of changeDSNTIP2End of change Yes TBSBPXML
TCPALVER TCP/IP ALREADY VERIFIED DSN6FAC DSNTIP5 Yes TCPALVER
TCPKPALV TCP/IP KEEPALIVE DSN6FAC DSNTIP5 Yes2 TCPKPALV
TEMPLATE_TIME TEMPLATE TIME DSN6SPRM DSNTIP6 Yes TPTM
TIME TIME FORMAT DSNHDECP DSNTIP4   DEFTIME
TIMELEN LOCAL TIME LENGTH DSNHDECP DSNTIP4   DEFTIMEL
TRACSTR TRACE AUTO START DSN6SYSP DSNTIPN   OPTRCAUT
TRACTBL TRACE SIZE DSN6SYSP DSNTIPN   CALC/OPTRCSIZ
TRKRSITE TRACKER SITE DSN6SPRM DSNTIPO   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 change--End of change
TSQTY TABLE SPACE ALLOCATION DSN6SYSP DSNTIP7 Yes TSQTY
TSTAMP TIMESTAMP ARCHIVES DSN6ARVP DSNTIPH Yes ARCHTS
TWOACTV NUMBER OF COPIES DSN6LOGP DSNTIPH   CALC/LOGSTWO
TWOARCH NUMBER OF COPIES DSN6LOGP DSNTIPH   CALC/ARCHTWO
TWOBSDS DSN6LOGP   TWOBSDS
UGCCSID UNICODE CCSID DSNHDECP DSNTIPF   UGCCSID
UIFCIDS UNICODE IFCIDS DSN6SYSP DSNTIPN Yes UIFCIDS
UMCCSID UNICODE CCSID DSNHDECP DSNTIPF   UMCCSID
UNION_COLNAME_7 DSN6SPRM Yes UNCOLN7
UNIT DEVICE TYPE 1 DSN6ARVP DSNTIPA Yes ARCHDEVT
UNIT2 DEVICE TYPE 2 DSN6ARVP DSNTIPA Yes ARCHDEV2
URCHKTH UR CHECK FREQ DSN6SYSP DSNTIPL1 Yes URCHKTH
URLGWTH UR LOG WRITE CHECK DSN6SYSP DSNTIPL1 Yes URLGWTH
USCCSID UNICODE CCSID DSNHDECP DSNTIPF   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 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 changeULBSGEnd of change
UTIL_TEMP_STORCLAS UTIL TEMP STORCLAS DSN6SPRM DSNTIP6 Yes 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 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 changeUBCDCEnd of change
UTILS_DUMP_CLASS_NAME DUMP CLASS NAME DSN6SPRM DSNTIP62 DSNTIP61 Yes 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 changeUZSORTEnd of change
UTIMOUT UTILITY TIMEOUT DSN6SPRM DSNTIP6 DSNTP61 Yes UTIMOUT
VOLTDEVT TEMP DS UNIT NAME DSN6SPRM DSNTIP6 Yes VOLTDEVT
WFDBSEP SEPARATE WORK FILES DSN6SPRM DSNTIP91   WFDBSEP
WFSTGUSE_AGENT_THRESHOLD AGENT LEVEL THRESHOLD DSN6SPRM DSNTIP91 Yes WFSAT
WFSTGUSE_SYSTEM_THRESHOLD SYSTEM LEVEL THRESHOLD DSN6SPRM DSNTIP91 Yes WFSST
WLMENV WLM ENVIRONMENT DSN6SYSP DSNTIPX Yes WLMENV
XLKUPDLT X LOCK FOR SEARCHED U/D DSN6SPRM DSNTIPI Yes XLKUPDLT
XML_RANDOMIZE_DOCID RANDOMIZE XML DOCID DSN6SYSP DSNTIP8 Yes XRDI
XML_RESTRICT_EMPTY_TAG DSN6SPRM Yes NOET
ZOSMETRICS DSN6SPRM Yes ZOSMETRI
ZHYPERLINK DB2 zHyperLinks SCOPE DSN6SPRM DSNTIPA3 Yes ZHYPL
ADVANCED CONFIGURATION OPTIONS DSNTIPR1  
APPL DEFAULTS DSNTIPO3  
APPLICATION DBRM DSNTIPT   DBRMLIB
APPLICATION LOAD DSNTIPT   RUNLIB
ARCHIVE LOG FREQ DSNTIPL   NUMHRARC
AUTH MEMBER DSNTIPM   MVSAMEMB
AUTH SEQUENCE DSNTIPM   MVSASEQN
Start of changeBP0 - BP49End of change DSNTIP1   BP0 - BP29
Start of changeBP8K0 - BP32K9End of change DSNTIP2   BP30 - BP32K9
BSDS AND ACTIVE LOG ICF CATALOG ALIAS DSNTIPA4: BSDS and active log panel   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 changeEnd of change
CICS® and IMS transaction invocation routines (DSNTIPRN) DSNTIPRA  
CICS COBOL LIBRARY DSNTIPW   CICSCOB
CICS EXCI LIBRARY DSNTIPW   CICSEXCI
CICS LOAD LIBRARY DSNTIPW   CICSMOD
CICS MACRO LIBRARY DSNTIPW   CICSMAC
CICS PL/I LIBRARY DSNTIPW   CICSPLI
C/CPP COMPILER LIBRARY> DSNTIPU   CCOMP
C/CPP COMPILER MODULE DSNTIPU   CPROG
C/CPP HEADER LIBRARY DSNTIPU   CHDRS
C/370 COMPILER MESSAGES DSNTIPU   CMSGS
CLIST ALLOCATION DSNTIPA2   VOLSDAT1
CLIST LIBRARY DSNTIPT   OUTCL
COBOL COMPILER LIBRARY DSNTIPU1   ICOBCOMP
COBOL LE PRELINKER PHASE DSNTIPU1   ICOBPRLK
COLUMNS DSNTIPD  
COMMAND PREFIX DSNTIPM   MVSSPREF
COMMAND SCOPE DSNTIPM   CMDSCOPE
COPY 1 NAME DSNTIPH   BSDSNAM1
COPY 2 NAME DSNTIPH   BSDSNAM2
Active logs: COPY 1 PREFIX DSNTIPH   LOGSPRE1
Active logs: COPY 2 PREFIX DSNTIPH   LOGSPRE2
CPP AUTO CALL LIBRARY DSNTIPU   CPPAUTCL
CPP CLASS LIB HEADERS DSNTIPU   CPPHDRS
CPP CLASS LIBRARY DSNTIPU   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 changeEnd of change
CPP PROCEDURE LIBRARY DSNTIPU   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 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 changeAGNEWIDSEnd of change
DATABASES DSNTIPD  
Database metadata routines (DSNTIPRK) DSNTIPRA  
DATABASES DSNTIPE  
DBRM LIBRARY DSNTIPT   DSNDBRM
DB2 administrator routines (DSNTIPRL) DSNTIPRA  
DB2 BASE Java™ DIR DSNTIPX1  
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 changeAGSSIDPXEnd of change
DB2 GENERIC LUNAME DSNTIPR   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 changeFUNCLVLEnd of change
DB2 LOCATION NAME DSNTIPR   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 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 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 changeDDPASSEnd of change
DD/MM/YYYY LOCAL DATE FORMAT DSNTIP8A Yes
DEADLOCK CYCLE DSNTIPJ  
DEADLOCK TIME DSNTIPJ  
DECLARATION LIBRARY DSNTIPT   SRCLIB
DEFINE CATALOG DSNTIPA2  
DISCONNECT IRLM DSNTIPJ   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 changeDSNPFPEEnd of change
Enter job card information for install and sample jobs DSBNTIPY  
EXECUTED STMTS DSNTIPD   NUMSTMTE
EXIT LIBRARY DSNTIPT   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
FOR DB2 REXX ROUTINES DSNTIPR1   WLMENVR
FOR DB2 UTILITIES ROUTINES DSNTIPR1   WLMENVU
FOR DB2 XML PROCESSING ROUTINES DSNTIPR1   WLMENVX
FOR MOST DB2 ROUTINES DSNTIPR1   WLMENVG
FOR MOST DB2 JAVA ROUTINES DSNTIPR1   WLMENVJ
FOR ROUTINES IDENTIFIED TO PROGRAM CONTROL DSNTIPR1   WLMENVP
FOR SERIALIZED ROUTINES DSNTIPR1   WLMENV1
FOR THE DB2 CICS ROUTINE DSNTIPR1   WLMENVC
FOR DB2 MQSERIES ROUTINES DSNTIPR1   WLMENVM
FOR DB2 WEB SERVICES ROUTINES DSNTIPR1   WLMENVW
FOR UNIFIED DEBUGGER ROUTINES DSNTIPR1   WLMENVD
GDDM LOAD MODULES DSNTIPW   GDDMLOAD
GDDM MACLIB DSNTIPW   GDDMMACS
GRANT EXECUTE (on many sub-panels) DSNTIPRA (sub-panels)  
GROUP ATTACH DSNTIPK   GRPATTNM
HIGH LEVEL ASSEMBLER LIB DSNTIPU   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 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 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 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 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 changeEnd of change
IBM LE LINK EDIT LIB DSNTIPU   LELKED
IBM LE PRELINK MSG LIB DSNTIPU   LEPLMSGL
IBM LE RUNTIME LIBRARY DSNTIPU   LERUN
IBM LE RUNTIME LIBRARY 2 DSNTIPU   LERUN2
IBM Text Search routines (DSNTIPRJ) DSNTIPRA  
IMS RESLIB DSNTIPW   RESLIB
INCLUDE LIBRARY DSNTIPT   DSNCHDRS
INIT JAVA HEAP SIZE DSNTIPX1  
INPUT MEMBER NAME DSNTIPA1  
INSERT FROM SELECT DSNTIP8A Yes
INSTALL GRANTEE(S) DSNTIPG   INSGRLST
INSTALL IC PREFIX Start of changeDSNTIPG1End of change   INSICPRE
INSTALL IRLM DSNTIPG  
INSTALL DS PREFIX Start of changeDSNTIPG1End of change   INSDSPRE
INSTALL PKG OWNER DSNTIPG   INSPKOWN
INSTALL SQL ID DSNTIPG   INSSQLID
INSTALL TYPE DSNTIPA1   INSTYPE
IRLM LOAD LIBRARY DSNTIPT   DSNIRLM
IRLM XCF GROUP NAME DSNTIPJ   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 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 changeDSNSPFPEnd of change
ISPF ISPLINK MODULE DSNTIPW   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 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 changeDSNSPFSEnd of change
IVP DATA LIBRARY DSNTIPT   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 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 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 changeIVPPKOWNEnd of change
Java and SQL procedure processing routines (DSNITPRF) DSNTIPRA   IVPSQLID
Java ENV DATA SET DSNTIPX1  
Java ENV VAR FILE DSNTIPX1  
JDBC AND SQLJ DLLS DSNTIPT   DSNLOD2
JDBC/SQLJ ENV VAR DIR DSNTIPX1  
JDBC/SQLJ INSTALL ID DSNTIPX1  
JSON routines (DSNTIPRQ) DSNTIPRA  
JVM ADDRESSING MODE DSNTIPX1  
JVM PROPERTIES FILE DSNTIPX1  
LIBRARY NAME PREFIX DSNTIPA1   DSNTLIBP
LIBRARY NAME SUFFIX DSNTIPA1   DSNTLIBS
LICENSE TERMS ACCEPTED DSNTIPO2  
LINK LIST ENTRY DSNTIPM   MVSLMEMB
LINK LIST LIBRARY DSNTIPT   DSNLINK
LINK LIST SEQUENCE DSNTIPM   MVSLSEQN
LOAD LIBRARY DSNTIPT   DSNLOAD
LOCK ENTRY SIZE DSNTIPJ   IRLMLKSZ
LOG COPY 1, BSDS 2 DSNTIPA4  
VOLSDAT6
DATACLS6
MGMTCLS6
STORCLS6
LOG COPY 2, BSDS 1 DSNTIPA4  
VOLSDAT7
DATACLS7
MGMTCLS7
STORCLS7
MBCS EBCDIC DSNTIP8A Yes
MEMBER IDENTIFIER DSNTIPJ   IRLMIDEN
NON-VSAM DATA DSNTIPA3  
VOLSDAT2
DATACLS2
MGMTCLS2
STORCLS2
MACRO LIBRARY DSNTIPT   DSNMACS
MAX APPL HEAP SIZE DSNTIPX1  
MAX STORAGE FOR LOCKS DSNTIPJ  
MQseries routines (DSNTIPRO) DSNTIPRA  
NUMBER OF LOCK ENTRIES DSNTIPJ   IRLMLTE
NUMBER OF LOGS DSNTIPL   LOGSNUM
NUMBER OF TCBS DSNTIPX   STORTCBS
OTC LICENSE USAGE DSNTIPO1  
OUTPUT MEMBER NAME DSNTIPA1  
PACKAGE LISTS DSNTIPD  
GRANT OWNER (on many sub-panels) DSNTIPRA (sub-panels)  
PACKAGE STATEMENTS DSNTIPD  
PACKAGES DSNTIPD  
PAGE PROTECT DSNTIPJ   IRLMPGPR
PARAMETER MODULE DSNTIPO3   DSNZPARM
PERMANENT UNIT NAME DSNTIPA3   VOLSDEVT
PLAN STATEMENTS DSNTIPD  
PLANS DSNTIPD  
PL/I COMPILER LIBRARY DSNTIPU1   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 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 changeAGEXECIDEnd of change
REMOTE LOCATION DSNTIPY  
RESYNC PORT Start of changeEnd of change   RESYNPRT
ROUTINES CREATOR DSNTIPG   AUTHID
Runtime statistics processing routines (DSNTIPRD) DSNTIPRA  
SAMPLE LIBRARY DSNTIPT   NEWSAMP
SECURE PORT Start of changeEnd of change   SECPORT
SEC DEF CREATOR DSNTIPG   SECDEFID
START IRLM CTRACE DSNTIPJ  
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 changeEnd of change
SORT LIBRARY DSNTIPW   SORTLIB
SUBGRP ATTACH DSNTIPK   SGRPATNM
SUBSYSTEM MEMBER DSNTIPM   MVSSMEMB
SUBSYSTEM SEQUENCE DSNTIPM   MVSSSEQN
SYSTEM MACLIB DSNTIPW   MACLIB
SYSTEM PROCEDURES DSNTIPW   PROCLIB
SYSTEM_TIME TEMPORAL QUERIES DSNTIP8A Yes
TABLES DSNTIPD  
TABLES IN STMT DSNTIPD  
TABLESPACES DSNTIPD  
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 changeTCPPORTEnd of change
TEMP CLIST LIBRARY DSNTIPT  
TEMPORARY UNIT NAME DSNTIPA3   TVOLDEVT
Trace formatting routines (DSNTIPRB) DSNTIPRA  
TS COLS WITH PRECISION OF 12 DSNTIP8A Yes
UPDATE RATE DSNTIPL   NUMCOMHR
Unified debugger for Java and SQL routines (DSNTIPRH) DSNTIPRA  
USE ZOSMF WORKFLOW DSNTIPA1  
Utility invocation routines (DSNTIPRC) DSNTIPRA  
VSAM CATALOG, DEFAULT AND WORK FILE DATABASE DSNTIPA3  
VOLSDAT3
DATACLS3
MGMTCLS3
STORCLS3
VIEWS DSNTIPD  
Web services/SOAP routines (DSNTIPRP) DSNTIPRA  
WLM ENV NAME (on many sub-panels) DSNTIPRA (sub-panels)  
WLM PROC NAME DSNTIPX   STORWLM
WORK FILE DB DSNTIPK   WKDBNAME
XML schema processing routines IVP(DSNTIPRI) DSNTIPRA  
Z/OS SDK HOME DIR DSNTIPX1  
Z/OS USS Java CLASSES DSNTIPX1  
Z/OS USS Java RUNTIME DSNTIPX1  
4K SORT PRIMARY SPACE DSNTIP9   S4KSPAC
4K SORT WORK TS'S   DSNTIP9   S4KNOTS
4K SORT WORK SEG SIZE DSNTIP9   S4KSGSZ
4K TEMP PRIMARY SPACE   DSNTIP9   T4KSPAC
4K TEMP WORK TS'S DSNTIP9   T4KNOTS
4K TEMP WORK SEG SIZE DSNTIP9   T4KSGSZ
32K SORT PRIMARY SPACE DSNTIP9   S32KSPAC
32K SORT WORK TS'S DSNTIP9   S32KNOTS
32K SORT WORK SEG SIZE   DSNTIP9   S32KSGSZ
32K TEMP PRIMARY SPACE DSNTIP9   T32KSPAC
32K TEMP WORK TS'S DSNTIP9   T32KNOTS
32K TEMP WORK SEG SIZE DSNTIP9   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. You must use a privilege set of the process that includes installation SYSADM authority or SECADM authority to update this parameter.
  3. This subsystem parameter can only be changed online. Restarting Db2 has no effect on the setting.
  4. 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