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.

If a REBIND PACKAGE or REBIND TRIGGER PACKAGE command changes certain bind options, the PLANMGMT option is ignored. For more information, see Package bind option changes that affect use of PLANMGMT.

Acceptable values:	EXTENDED, OFF, BASIC
Default:	EXTENDED
Update:	option 29 on panel DSNTIPB
DSNZP`xxx`:	DSN6SPRM PLANMGMT

EXTENDED

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 change FL 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 change EXTENDED is the default value. 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.

Package bind option changes that affect use of PLANMGMT

If a REBIND PACKAGE or REBIND TRIGGER PACKAGE command changes any of the following bind options for a package, the changes affect use of the PLANMGMT option for the package.

OWNER
QUALIFIER
ENABLE
DISABLE
PATH
PATHDEFAULT
IMMEDWRITE
BUSTIMESENSITIVE
SYSTIMESENSITIVE
ARCHIVESENSITIVE

That is, Db2 returns an error if PLANMGMT(EXTENDED) or PLANMGMT(BASIC) is also specified when any of the options in the preceding list are changed. If PLANMGMT(OFF) is specified, Db2 purges all saved packages copies.

If the PLANMGMT setting for the package is inherited from the value of the PLANMGMT subsystem parameter, and the value of any of the option is preceding list is changed, Db2 internally disables the PLANMGMT option. As a result, Db2 purges all saved package copies.

However, if the previously listed options are specified without changing the existing values, Db2 processes the command as if the option were not specified. In that case, an error message is not issued, and the specified PLANMGMT option is accepted or the PLANMGMT subsystem parameter takes effect.