Plan management polices

You can use plan management policies enable you to save historical information about the access paths for SQL statements.

Plan management policy options

Begin program-specific programming interface information.

You can specify the following plan management policies:

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 changeEXTENDED 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.

You can specify the plan management policy for a package by specifying the PLANMGMT option. If you omit the PLANMGMT option, Db2 uses the PLANMGMT subsystem parameter setting.

End program-specific programming interface information.