Improved access path reuse with warnings

The new APREUSE(WARN) bind option improves the ability to reuse existing access paths for as many statements as possible.

In earlier versions, access path stabilization through the APREUSE option of the BIND PACKAGE and REBIND PACKAGE commands is possible only when the access paths for all statements in a package can be reused successfully. If reuse fails for any statement in a package, reuse cannot be applied to any statements in that package.

In Db2 11, the APREUSE(WARN) option enables a package to be successfully rebound when the access paths for some statements cannot be reused. When an access path cannot be reused, a new access path is chosen for the statement.