PLANMGMT—Type of plan management
Use the Modify Type of Plan Management panel or the PLANMGMT command to specify the type of plan management that will be used by default when the PLANMGMT option is not specified in the REBIND command.
Modify Type of Plan Management panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : TYPE OF PLAN MANAGEMENT
Type the new Type of Plan Management you wish to change to. Then Press Enter.
Plan Management Type
Management Type ________ (OFF, BASIC, EXTENDED)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
OFF | Plans will not be managed when no PLANMGMT is specified in the REBIND command. |
BASIC | Basic plan management will be used when no PLANMGMT is specified in the REBIND command. |
EXTENDED | Extended plan management will be used when no PLANMGMT is specified in the REBIND command. |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Management Type | PLANMGMT | DSN6SPRM | PLANMGMT |