Securing OPERTUNE by function


OPERTUNE security summary divides OPERTUNE functions into logical categories. The categories are divided into function type, function, and security profile. The following values are used to define each security profile:

A—system ID (your OPERTUNE SSID)
B—subsystem (your Db2 subsystem)
C—function type
D—function
E—connection ID (extended security only)
F—authorization ID (extended security only)
G—correlation ID (extended security only)
H—plan name (extended security only)
I—catalog name (extended security only)
J—data base name (extended security only)
K—table space name (extended security only)

Warning

Note

You can replace any value in the security profile with *.

OPERTUNE security summary

OPERTUNE Actions

Function Type

Function

Security Profile

ZPARMs (SET, RESET)

ABEXP

Element

ABEXP

A.B.C.D.

ABIND

Element

ABIND

A.B.C.D.

ACCESS

Security

ACCESS

A.B.C.D.

ACCUMACC

Element

ACCUMACC

A.B.C.D.

ACCUMUID

Element

ACCUMUID

A.B.C.D.

AEXITLIM

Element

AEXITLIM

A.B.C.D.

ARC2FRST

Element

ARC2FRST

A.B.C.D.

ARCALLOC

Element

ARCALLOC

A.B.C.D.

ARCBLKSZ

Element

ARCBLKSZ

A.B.C.D.

ARCBSDS

Element

ARCBSDS

A.B.C.D.

ARCCATLG

Element

ARCCATLG

A.B.C.D.

ARCCOMP

Element

ARCCOMP

A.B.C.D.

ARCHIVE

Element

ARCHIVE

A.B.C.D.

ARCPREF

Element

ARCPREF

A.B.C.D.

ARCPROT

Security

ARCPROT

A.B.C.D.

ARCRETN

Element

ARCRETN

A.B.C.D.

ARCSTMP

Element

ARCSTMP

A.B.C.D.

ARCUNIT

Element

ARCUNIT

A.B.C.D.

ARCWTOR

Element

ARCWTOR

A.B.C.D.

ASSIST

Element

ASSIST

A.B.C.D.

AUTHCACH

Element

AUTHCACH

A.B.C.D.

AUTHCHK

Security

AUTHCHK

A.B.C.D.

BINDNV

Element

BINDNV

A.B.C.D.

BMPTOUT

Element

BMPTOUT

A.B.C.D.

BPn

Element

BPn

A.B.C.D.

CACHEDYN

Element

CACHEDYN

A.B.C.D.

CATTBUPD

Element

CATTBUPD

A.B.C.D.

CDSSRDEF

Element

CDSSRDEF

A.B.C.D.

CHKPTFRQ

Element

CHKPTFRQ

A.B.C.D.

COMAXPAG

Element

COMAXPAG

A.B.C.D.

CONTSTOR

Element

CONTSTOR

A.B.C.D.

COORDNTR

Element

COORDNTR

A.B.C.D.

CORVRSTH

Element

CORVRSTH

A.B.C.D.

COTIMINT

Element

COTIMINT

A.B.C.D.

DBACRVW

Element

DBACRVW

A.B.C.D.

DBPROTCL

Element

DBPROTCL

A.B.C.D.

DDFINTV

Element

DDFINTV

A.B.C.D.

DDFCQTM

Element

DDFCQTM

A.B.C.D.

DDFRBS

Element

DDFRBS

A.B.C.D.

DEFID

Security

DEFID

A.B.C.D.

DESCSTAT

Element

DESCSTAT

A.B.C.D.

DISABSCL

Element

DISABSCL

A.B.C.D.

DLDFREQ

Element

DLDFREQ

A.B.C.D.

DLITOUT

Element

DLITOUT

A.B.C.D.

DSSTIME

Element

DSSTIME

A.B.C.D.

DSVCI

Element

DSVCI

A.B.C.D.

DUALARC

Element

DUALARC

A.B.C.D.

EDMBFIT

Element

EDMBFIT

A.B.C.D.

EDMDBDC

Element

EDMDBDC

A.B.C.D.

EDMDSPAC

Element

EDMDSPAC

A.B.C.D.

EDMPA2GB

Element

EDMPA2GB

A.B.C.D.

EDMPOOL

Element

EDMPOOL

A.B.C.D.

EDMSKPOL

Element

EDMSKPOL

A.B.C.D.

EDMSTMTC

Element

EDMSTMTC

A.B.C.D.

EDPROP

Element

EDPROP

A.B.C.D.

EVALUNC

Element

EVALUNC

A.B.C.D.

EXPLAIN+

Element

EXPLAIN+

A.B.C.D.

EXTRAREQ

Element

EXTRAREQ

A.B.C.D.

EXTRASRV

Element

EXTRASRV

A.B.C.D.

EXTSEC

Element

EXTSEC

A.B.C.D.

GBPn

Element

GBPn

A.B.C.D.

IDTHTOIN

Element

IDTHTOIN

A.B.C.D.

IDXBPOOL

Element

IDXBPOOL

A.B.C.D.

IMMEDWRI

Element

IMMEDWRI

A.B.C.D.

IMPDB

Element

IMPDB

A.B.C.D.

IMPDSDEF

Element

IMPDSDEF

A.B.C.D.

IMPTSCMP

Element

IMPTSCMP

A.B.C.D.

IMPTSSEG

Element

IMPTSSEG

A.B.C.D.

INBUFF

Element

INBUFF

A.B.C.D.

IRLMECSA

Element

IRLMECSA

A.B.C.D.

IXQTY

Element

IXQTY

A.B.C.D.

LOBVALA

Element

LOBVALA

A.B.C.D.

LOBVALS

Element

LOBVALS

A.B.C.D.

LOGAPSTG

Element

LOGAPSTG

A.B.C.D.

LOGTHRSH

Element

LOGTHRSH

A.B.C.D.

LRDRTHLD

Element

LRDRTHLD

A.B.C.D.

MAINTYPE

Element

MAINTYPE

A.B.C.D.

MAXDSN

Element

MAXDSN

A.B.C.D.

MAXKEEPD

Element

MAXKEEPD

A.B.C.D.

MAXLOCKS

Element

MAXLOCKS

A.B.C.D.

MAXOFILR

Element

MAXOFILR

A.B.C.D.

MAXTEMPS

Element

MAXOTEMPS

A.B.C.D.

MAXTHDS

Element

MAXTHDS

A.B.C.D.

MAXTYPE1

Element

MAXTYPE1

A.B.C.D.

MAXZDES

Element

MAXZDES

A.B.C.D.

MGEXTSZ

Element

MGEXTSZ

A.B.C.D.

MINDVSCL

Element

MINDVSCL

A.B.C.D.

MINSTOR

Element

MINSTOR

A.B.C.D.

MSGLIMIT

Element

MSGLIMIT

A.B.C.D.

MXDTCACH

Element

MXDTCACH

A.B.C.D.

MXNUMCUR

Element

MXNUMCUR

A.B.C.D.

MXSTPROC

Element

MXSTPROC

A.B.C.D.

NPGTHRSH

Element

NPGTHRSH

A.B.C.D.

OJPERFEH

Element

OJPERFEH

A.B.C.D.

OPTHINTS

Element

OPTHINTS

A.B.C.D.

OUTBUFF

Element

OUTBUFF

A.B.C.D.

PADIX

Element

PADIX

A.B.C.D.

PARAMDEG

Element

PARAMDEG

A.B.C.D.

PARTKEYU

Element

PARTKEYU

A.B.C.D.

PCLOSE

Element

PCLOSE

A.B.C.D.

PFBPn

Element

PFBPn

A.B.C.D.

PKGLDTOL

Element

PKGLDTOL

A.B.C.D.

POOLINAC

Element

POOLINAC

A.B.C.D.

PTASKROL

Element

PTASKROL

A.B.C.D.

QUIESCE

Element

QUIESCE

A.B.C.D.

READTAPE

Element

READTAPE

A.B.C.D.

RECALL

Element

RECALL

A.B.C.D.

RECALLTM

Element

RECALLTM

A.B.C.D.

RELCURHL

Element

RELCURHL

A.B.C.D.

RESET


RESET
You must have authorization to set the element.


RESTTPUN

Element

RESTTPUN

A.B.C.D.

RESYNC

Element

RESYNC

A.B.C.D.

RETLWAIT

Element

RETLWAIT

A.B.C.D.

RETVLCFK

Element

RETVLCFK

A.B.C.D.

RIDBLKS

Element

RIDBLKS

A.B.C.D.

RIDPOOL

Element

RIDPOOL

A.B.C.D.

RLFAUTH

Element

RLFAUTH

A.B.C.D.

RLFERR

Element

RLFERR

A.B.C.D.

RLFERRD

Element

RLFERRD

A.B.C.D.

RLIMIT

Element

RLIMIT

A.B.C.D.

RRFRMDMP

Element

RRFRMDMP

A.B.C.D.

RRULOCK

Element

RRULOCK

A.B.C.D.

SARGSWRP

Element

SARGSWRP

A.B.C.D.

SEQCACH

Element

SEQCACH

A.B.C.D.

SEQPRES

Element

SEQPRES

A.B.C.D.

SITETYPE

Element

SITETYPE

A.B.C.D.

SJMXPOOL

Element

SJMXPOOL

A.B.C.D.

SJTABLES

Element

SJTABLES

A.B.C.D.

SKIPUNCI

Element

SKIPUNCI

A.B.C.D.

SMF89

Element

SMF89

A.B.C.D.

SMSDCFL

Element

SMSDCFL

A.B.C.D.

SMSDCIX

Element

SMSDCIX

A.B.C.D.

SORTPOOL

Element

SORTPOOL

A.B.C.D.

STARJOIN

Element

STARJOIN

A.B.C.D.

STATCLUS

Element

STATCLUS

A.B.C.D.

STATFREQ

Element

STATFREQ

A.B.C.D.

STATHIST

Element

STATHIST

A.B.C.D.

STATROLL

Element

STATROLL

A.B.C.D.

STATSINT

Element

STATSINT

A.B.C.D.

STORMXAB

Element

STORMXAB

A.B.C.D.

STORPROC

Element

STORPROC

A.B.C.D.

STORTIME

Element

STORTIME

A.B.C.D.

SUPERRS

Element

SUPERRS

A.B.C.D.

SVOLARC

Element

SVOLARC

A.B.C.D.

SYNCVAL

Element

SYNCVAL

A.B.C.D.

SYSADM

Security

SYSADM

A.B.C.D.

SYSLEVBK

Element

SYSLEVBK

A.B.C.D.

SYSOPR

Security

SYSOPR

A.B.C.D.

TBSBPOOL

Element

TBSBPOOL

A.B.C.D.

TBSBP16K

Element

TBSBP16K

A.B.C.D.

TBSBP32K

Element

TBSBP32K

A.B.C.D.

TBSBP8K

Element

TBSBP8K

A.B.C.D.

TCPALVER

Security

TCPALVER

A.B.C.D.

TCPKPALV

Element

TCPKPALV

A.B.C.D.

TIMEOUT

Element

TIMEOUT

A.B.C.D.

TSQTY

Element

TSQTY

A.B.C.D.

UIFCIDS

Element

UIFCIDS

A.B.C.D.

URLCHKTH

Element

URLCHKTH

A.B.C.D.

URLGWTH

Element

URLGWTH

A.B.C.D.

UTDUCLNM

Element

UTDUCLNM

A.B.C.D.

UTIMOUT

Element

UTIMOUT

A.B.C.D.

VOLTDEVT

Element

VOLTDEVT

A.B.C.D.

WLMENV

Element

WLMENV

A.B.C.D.

XLKUPDLT

Element

XLKUPDLT

A.B.C.D.

PERMANENT parm

Element

PERMCHG

A.B.C.D.

ZPARMS (Query)

Info

QUERY

A.B.C.D.

Operational assist

Active log manipulation 

Oper

ADDLOG, REMLOG, CREATLOG

A.B.C.D

Cancel threads/connections

Oper

CANCEL

A.B.C.D.E. F.G.H

Update archive logs

Oper

UPDATE

A.B.C.D

Initiate checkpoint

Oper

CHECKPT

A.B.C.D

Freeform commands

MVS

MVS

A.C.D

Freeform commands

DB2

DB2

A.C.D

Free table spaces

Oper

FREE, STOP

A.B.C.D.I.J .K

Reload user exits

Oper

RELOAD

A.B.C.D

Change DDF parameters

Oper

DDF

A.B.C.D

Group buffer pool ops

Oper

CASTOUT

A.B.C.D

Open data component ops

Oper

CHANGESX

A.B.C.D

Reload DSNHDECP

Oper

RELOAD

A.B.C.D

Peer log operations

Oper

REMOVE

A.B.C.D

Tablespace in exception status

Oper

ISSUE

A.B.C.D

Utility job status

Oper

TERMUTIL

A.B.C.D

RESET ALL


You must have authorization to reset each element set.


Administration

User profiles

Custom

CUSTUSER

A.C.D

System profiles

Custom

CUSTSYS

A.C.D

Security profiles

Custom

CUSTUSER

A.C.D

Group profiles

Custom

CUSTGRP

A.C.D

Schedule profiles

Custom

CUSTSCH

A.C.D

Query information

Info

QUERY

A.B.C.D

History information

Info

HISTORY

A.C.D

Maintenance level

Info

MAINT

None

Product authorization

NA

NA

None

Host selection

NA

NA

None

Profile enqueue

NA

NA

None

Tracing switch

Alter

TRACE

A.B.C.D

Reload OPERTUNE exits

Custom

RELOADX

A.C.D

Facilities available via console commands only





















ALTER













ACTIVATE

A.C.D

ADDSYS

A.C.D

APPLID

A.C.D

BUFSIZE

A.C.D

LOG

A.C.D

RECINIT

A.C.D

REMSYS

A.C.D

RUSIZE

A.C.D

SAMPFREQ

A.C.D

SYNCTIME

A.C.D

SYSLOG

A.C.D

TRACE

A.C.D

UNITVAL

A.C.D

XCF

A.C.D

VTAM





ADDREMOT

A.C.D

CONNECT

A.C.D

DELREMOT

A.C.D

DISCONN

A.C.D

SEND

None

STATUS

A.C.D

Info

DISPLAY

A.C.D

MVS

SHUTDOWN

A.C.D

Related topic

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 12.1