DB2 10 for z/OS – New feature announcement

DB2 10 for z/OS has been GA since October 2010, but one or two features weren’t quite ready at that time. One of the more eagerly awaited enhancements extend the access path management capabilities of DB2 10, via the APREUSE and APCOMPARE options of the BIND command.

With APREUSE, DB2 attempts to keep the same access paths that existed prior to the BIND/REBIND. So, while the package structures are created afresh, if the reuse is successful, the new and old access paths are structurally identical in terms of the EXPLAIN information exposed in PLAN_TABLE. The APCOMPARE option instructs DB2 to compare the new access path with the old one and take action (either issue a warning or cancel the bind process) if they are different.

These new options can be enabled via APAR PM25679, which closed on 28th July 2011. See https://www-304.ibm.com/support/docview.wss?crawler=1&uid=swg1PM25679 for more details.

This entry was posted in DB2, DB2 10, z/OS and tagged , , , , , . Bookmark the permalink.