PLAN MANAGEMENT field (PLANMGMT subsystem parameter)
The PLANMGMT subsystem parameter specifies which default plan management policy to use when the PLANMGMT option is not explicitly specified for the bind or rebind of a package.
Acceptable values: | OFF, BASIC, EXTENDED |
Default: | EXTENDED |
Update: | option 19 on panel DSNTIPB |
DSNZPxxx: | DSN6SPRM PLANMGMT |
- OFF
- DB2® does not store access path information for SQL queries.
- BASIC
- DB2 stores access path information for SQL queries in the repository. In addition, one old access path is retained. This access path is referred to as the PREVIOUS copy.
- EXTENDED
- DB2 stores access path information for SQL queries in the repository. In addition, two old access paths are retained. These access paths are referred to as the PREVIOUS and ORIGINAL copies. This is the default setting of the PLANMGMT subsystem parameter.