Static plan stability enhancements

Db2 12 introduces improvements to the usability of static plan stability features.

Db2 12 introduces the following static plan stability enhancements:
  • You can now specify that the FREE PACKAGE command free only the previous or original packages copies by specifying PREVIOUS or ORIGNAL for the PLANMGMTSCOPE option.
  • Start of changeIf you specify INACTIVE, PREVIOUS, or ORIGINAL for the PLANMGMTSCOPE option, the FREE PACKAGE command can now complete while applications that use the package are still running, removing the necessity of application outages for maintenance of inactive package copies.End of change
  • Improved explain information for APREUSE and APCOMPARE for static plan stability (see columns added to DSN_STATEMNT_TABLE).
  • Preservation of LASTUSED for BIND REPLACE of the same version.
  • REBIND PACKAGE provides a new option APREUSESOURCE to allow APREUSE to use a PREVIOUS or ORIGINAL copy explicitly.
  • Support for statement concentration via a BIND parameter
  • Statement concentration for CREATE and ALTER