PLAN MANAGEMENT field (PLANMGMT subsystem parameter)

The PLANMGMT subsystem parameter specifies which default plan management policy to use for storing information about access paths information for SQL statements when the PLANMGMT bind option is not explicitly specified for the rebind of a package.

Acceptable values: EXTENDED, OFF, BASIC,
Default: EXTENDED
Update: option 29 on panel DSNTIPB
DSNZPxxx: DSN6SPRM PLANMGMT
Start of changeEXTENDEDEnd of change
Start of change

Db2 saves the active copy, and two older copies, which are known as the previous and original copies. Db2 replaces the previous copy with the former active copy and saves the newest copy as the active copy. Db2 saves the original copy at the first rebind that EXTENDED is specified and retains the original copy unchanged at subsequent rebinds.

Start of changeFL 505 Multiple phased-out copies can also be saved for phase-in of package rebinds. For more information, see Phase-in of package rebinds.End of change

Start of changeEXTENDED is the default value.End of change

End of change
BASIC
Db2 saves the active copy and one older copy, which is known as the previous copy. Db2 replaces the previous copy path with the former active copy and saves the newest copy the active copy.
OFF
No copies are saved.