Installation panel

The following table provides a cross reference of OPERTUNE elements, ordered by installation panel.

OPERTUNE elements by installation panel

Installation panel	OPERTUNE element	CLIST parameter	ZPARM macro	ZPARM parameter
DSNTIJUZ	DISABSCL	None	DSN6SPRM	DISABSCL¹
DSNTIP1	IDXBPOOL	IDXBPOOL	DSN6SYSP	IDXBPOOL
	TBSBPOOL	TBSBPOOL	DSN6SYSP	TBSBPOOL
	TBSBP16K²	TBSBP16K	DSN6SYSP	TBSBP16K
	TBSBP32K²	TBSBP32K	DSN6SYSP	TBSBP32K
	TBSBP8K²	TBSBP8K	DSN6SYSP	TBSBP8K
	TBSBPLOB²	TBSBPLOB	DSN6SYSP	TBSBPLOB
	TBSBPXML²	TBSBPXML	DSN6SYSP	TBSBPXML
DSNTIP1 DSNTIP2	BPn n= 0 to 49 (4-KB buffers) 8K to 8K9 (8-KB buffers) 16K0 to 16K9 (16-KB buffers) 32K to 32K9 (32-KB buffers)	BPn	None	None
DSNTIP4	DESCSTAT	DESCSTAT	DSN6SPRM	DESCSTAT
DSNTIP5	DBPROTCL	DBPROTCL	DSN6SYSP	DBPROTCL
	EXTRAREQ	EXTRAREQ	DSN6SYSP	EXTRAREQ
	EXTRASRV	EXTRASRV	DSN6SYSP	EXTRASRV
	POOLINAC	POOLINAC	DSN6FAC	POOLINAC
	TCPALVER	TCPALVER	DSN6FAC	TCPALVER
	TCPKPALV¹	None	DSN6FAC	TCPKPALV
DSNTIP6	RESTTPUN²	RESTORTU	DSN6SPRM	RESTORE_TAPEUNITS
	RRFRMDMP²	RESRECFD	DSN6SPRM	RESTORE_RECOVER_FROMDUMP
	STATCLUS²	STATCLUS	DSN6SPRM	STATCLUS
	SYSLEVBK²	SYSLVLBK	DSN6SPRM	SYSTEM_LEVEL_BACKUPS
	UTDUCLNM²	UTDUMPCL	DSN6SPRM	UTILS_DUMP_CLASS_NAME
DSNTIP7	DSVCI¹	None	DSN6SYSP	DSVCI
	IMPDSDEF²	IMPDSDEF	DSN6SYSP	IMPDSDEF
	IMPTSCMP²	IMPTSCMP	DSN6SYSP	IMPTSCMP
	IXQTY¹	None	DSN6SYSP	IXQTY
	LOBVALA	LOBVALA	DSN6SYSP	LOBVALA
	LOBVALS	LOBVALS	DSN6SYSP	LOBVALS
	MGEXTSZ¹	None	DSN6SYSP	MGEXTSZ
DSNTIP8	CACHEDYN	CACHEDYN	DSN6SPRM	CACHEDYN
	CDSSRDEF	CDSSRDEF	DSN6SPRM	CDSSRDEF
	EDMBFIT	SPRMEBF	DSN6SPRM	EDMBFIT
	EVALUNC¹	EVALUNC	DSN6SPRM	EVALUNC
	IMMEDWRI¹	None	DSN6GRP	IMMEDWRI
	MAINTYPE¹	None	DSN6SPRM	MAINTYPE
	OPTHINTS	OPTHINTS	DSN6SPRM	OPTHINTS
	PARAMDEG	PARAMDEG	DSN6SPRM	PARAMDEG
	PARTKEYU	SPRMPKYU	DSN6SPRM	PARTKEYU
	REFSHAGE¹	None	DSN6SPRM	REFSHAGE
	RELCURHL	RELCURHL	DSN6SPRM	RELCURHL
	RETVLCFK	RETVLCFK	DSN6SPRM	RETVLCFK
	MXDTCACH²	MXDTCACH	DSN6SPRM	MXDTCACH
DSNTIP9	MAXTEMPS²	MAXTEMPS	DSN6SPRM	MAXTEMPS
DSNTIPA	ARCALLOC	None	DSN6ARVP	PRIQTY SECQTY ALCUNIT
	ARCBLKSZ	ARCHSIZE	DSN6ARVP	BLKSIZE
	ARCBSDS	ARCHMAXV	DSN6LOGP	MAXARCH
	ARCCATLG	ARCHCTLG	DSN6ARVP	CATALOG
	ARCCOMP	ARCHCOMP	DSN6ARVP	COMPACT
	ARCRETN	ARCRETN	DSN6ARVP	ARCRETN
	ARCUNIT	ARCHDEVT	DSN6ARVP	UNIT
	ARCWTOR	ARCHWTOR	DSN6ARVP	ARCWTOR
	QUIESCE	None	DSN6ARVP	QUIESCE
	READTAPE	ARCHDEAP ARCHMRTU	DSN6LOGP	DEALLCT MAXRTU
	SVOLARC	None	DSN6ARVP	SVOLARC
	VOLTDEVT¹	None	DSN6SPRM	VOLTDEVT
DSNTIPB	CHGDC¹	None	DSN6SPRM	CHGDC
	DSSTIME¹	None	DSN6SYSP	DSSTIME
	EDPROP¹	None	DSN6SPRM	EDPROP
	STARJOIN¹	None	DSN6SPRM	STARJOIN
	SKIPUNCI¹	None	DSN6SPRM	SKIPUNCI
	STARJOIN¹	None	DSN6SPRM	STARJOIN
	TSQTY¹	None	DSN6SYSP	TSQTY
	UIFCIDS¹	None	DSN6SYSP	UIFCIDS
	UNCOLNM7¹	None	DSN6SPRM	UNION_COLNAME_7
DSNTIPC	EDMDBDC¹	None	DSN6SPRM	EDMDBDC
	EDMDSPAC³	EDMDSPAC	DSN6SPRM	EDMDSPAC
	EDMPOOL	None	DSN6SPRM	EDMPOOL
	EDMSKPOL²	None	DSN6SPRM	EDM_SKELETON_POOL
	EDMSTMTC¹	None	DSN6SPRM	EDMSTMTC
	MAXDSN	NUMCONDB	DSN6SPRM	DSMAX
	RIDPOOL	RIDPOOL	DSN6SPRM	MAXRBLK
	RIDBLKS	RIDBLKS	DSN6SPRM	MAXRBLK
	SORTPOOL	SORTPOOL	DSN6SPRM	SRTPOOL
DSNTIPD	XMLVALA²	XMLVALA	DSN6SYSP	XMLVALA
DSNTIPD	XMLVALS²	XMLVALS	DSN6SYSP	XMLVALS
DSNTIPE	CONTSTOR	CONTSTOR	DSN6SPRM	CONTSTOR
	LRDRTHLD¹	None	DSN6SYSP	LRDRTHLD
	MAXKEEPD	MAXKEEPD	DSN6SPRM	MAXKEEPD
	MAXOFILR²	MAXOFILR	DSN6SYSP	MAXOFILR
	MAXTHDS	NUMCONCR NUMCONRM NUMCONTS NUMCONBT CONDBAT	DSN6SYSP	CTHREAD MAXDBAT IDFORE IDBACK CONDBAT
	MINSTOR	SPRMMSTG	DSN6SPRM	MINSTOR
	PADIX¹	None	DSN6SPRM	PADIX
	SEQCACH	SEQCACH	DSN6SPRM	SEQCACH
	SEQPRES	SEQPRES	DSN6SPRM	SEQPRES
DSNTIPH	ARCPREF	ARCHPRE1 ARCHPRE2	DSN6ARVP	ARCPFX1 ARCPFX2
	ARCTSTMP	ARCHTS	DSN6ARVP	TSTAMP
	DUALARC	ARCHTWO	DSN6LOGP	TWOARCH
DSNTIPI	BMPTOUT	BMPTOUT	DSN6SPRM	BMPTOUT
	DLITOUT	DLITOUT	DSN6SPRM	DLITOUT
	RETLWAIT	SPRMWAI	DSN6SPRM	RETLWAIT
	RRULOCK	RRULOCK	DSN6SPRM	RRULOCK
	TIMEOUT	IRLMWAIT	DSN6SPRM	IRLMRWT
	UTIMOUT	UTIMOUT	DSN6SPRM	UTIMOUT
	XLKUPDLT	XLKUPDLT	DSN6SPRM	XLKUPDLT
DSNTIPJ	IRLMECSA	IRLMECSA	None	None
DSNTIPJ	MAXLOCKS	IRLMLKTS IRLMLKUS	DSN6SPRM	NUMLKTS NUMLKUS
DSNTIPK	ASSIST	ASSIST	DSN6GRP	ASSIST
DSNTIPK	COORDNTR	COORDNTR	DSN6GRP	COORDNTR
DSNTIPL	CHKPTFRQ	OPCHKFRQ	DSN6SYSP	CHKFREQ
	DLDFREQ	DLDFREQ	DSN6SYSP	DLDFREQ
	LOGAPSTG	LOGAPSTG	LOGAPSTG	LOGAPSTG
	OUTBUFF	LOGOUTPT	DSN6LOGP	OUTBUFF
	PCLOSE	PCLOSEN PCLOSET	DSN6SYSP	PCLOSEN PCLOSET
	URCHKTH	URCHKTH	DSN6SYSP	URCHKTH
	URLGWTH	URLGWTH	DSN6SYSP	URLGWTH
DSNTIPM	SUPERRS	SPRMSAE	DSN6SPRM	SUPERRS
DSNTIPN	ACCUMACC¹	None	DSN6SYSP	ACCUMACC
	ACCUMUID¹	None	DSN6SYSP	ACCUMUID
	STATFREQ	OPSTATIM	DSN6SYSP	STATIME
	SYNCVAL	SYNCVAL	DSN6SYSP	SYNCVAL
DSNTIPO	ABEXP	None	DSN6SPRM	ABEXP
	ABIND	ABIND	DSN6SPRM	ABIND
	ARC2FRST	ARC2FRST	DSN6LOGP	ARC2FRST
	RECALL	RECALL	DSN6SPRM	RECALL
	RECALLTM	RECALLD	DSN6SPRM	RECALLD
	RLFERR	None	DSN6SYSP	RLFERR
	SITETYPE	None	DSN6SPRM	SITETYP
	STATHIST	STATHIST	DSN6SPRM	STATHIST
	STATROLL	SPRMSTRL	DSN6SPRM	STATROLL
	STATSINT	None	DSN6SPRM	STATSINT
DSNTIPP	AEXITLIM¹	None	DSN6SPRM	AEXITLIM
	ARCPROT	PROTARAC	DSN6ARVP	PROTECT
	AUTHCACH	AUTHCACH	DSN6SPRM	AUTHCACH
	AUTHCHK	PROTAUTH	DSN6SPRM	AUTH
	BINDNV	BINDNV	DSN6SPRM	BINDNV
	DBACRVW	SPRMCRVW	DSN6SPRM	DBACRVW
	DEFID	PROTUNKN	DSN6SPRM	DEFLTID
	RLFAUTH	RLFAUTH	DSN6SYSP	RLFAUTH
	SYSADM	PROTADMN PROTADM2	DSN6SPRM	SYSADM SYSADM2
	SYSOPR	PROTOPR1 PROTOPR2	DSN6SPRM	SYSOPR1 SYSOPR2
DSNTIPR	EXTSEC	EXTSEC	DSN6SYSP	EXTSEC
	IDTHTOIN	IDTHTOIN	DSN6FAC	IDTHTOIN
	RESYNC	RESYNC	DSN6FAC	RESYNC
	RLFERRD	None	DSN6FAC	RLFERRD
	MAXTYPE1	MAXTYPE1	DSN6FAC	MAXTYPE1
DSNTIPX	MXNUMCUR¹	None	DSN6SPRM	MAX_NUM_CUR
	MXSTPROC¹	None	DSN6SPRM	MAX_ST_PROC
	STORMXAB	STORMXAB	DSN6SYSP	STORMXAB
	STORPROC	STORPROC	DSN6SYSP	STORPROC
	STORTIME	STORTIME	DSN6SYSP	STORTIME
	WLMENV	WLMENV	DSN6SYSP	WLMENV
None	ACCESS	None	None	None
	ARCHIVE	None	DSN6LOGP	OFFLOAD
	CATTBUPD	SPRMCTU	DSN6SPRC	None
	COMAXPAG	SPRMCO1	DSN6SPRC	None
	CORVRSTH	SPRMCO2	DSN6SPRC	None
	COTIMINT	SPRMSCT	DSN6SPRC	None
	DDFINTV	SPRMINT	DSN6SPRC	None
	DDFQCTM	SPRMQCT	DSN6SPRC	None
	DDFRBS	SPRMDRB	DSN6SPRC	None
	EXPLAIN+³	None	DSN6SPRC	None
	GBPn; n= 0 to 49 (4-KB buffers) 8K0 to 8K9 (8-KB buffers) 16K0 to 16K9 (16-KB buffers) 32K to 32 K9 (32-KB buffers)	None	None	None
	MAXZDES	SPRMMDE	DSN6SPRC	None
	MINDVSCL	MINDVSCL	DSN6SPRM	MINDVSCL
	MSGLIMIT	None	None	None
	NPGTHRSH	None	DSN6SPRM	NPGTHRSH
	OJPERFEH¹	None	DSN6SPRM	OJPERFEH
	PFBPn n= 0 to 49 (4-KB buffers) 8K to 8K9 (8-KB buffers) 16K0 to 16K9 (16-KB buffers) 32K to 32K9 (32-KB buffers)	None	None	None
	PKGLDTOL	None	DSN6SPRM	PKGLDTOL
	PLANMGMT²	PLANMGMT	DSN6SPRM	PLANMGMT
	PTASKROL	PTASK	DSN6SYSP	PTASKROL
	RLIMIT	None	None	None
	SARGSWRP	None	DSN6SPRM	SARGSWRP
	SJTABLES	None	DSN6SPRM	SJTABLES
	SMF89¹	None	DSN6SYSP	SMF89
	SMSDCFL	SPRMDCFL	DSN6SPRM	SMSDCFL
	SMSDCIX	SPRMDCIX	DSN6SPRM	SMSDCIX

^{1 This element applies only to Db2 8.1 and later releases.}

^{2 This element applies only to Db2 9.1 and later releases.}

^{3 This element applies only to Db2 7.1.}

Installation panel

OPERTUNE for DB2 12.1

On this page