Hello SYSVIEW for Db2 users,
Currently, SYSVIEW for Db2 displays the access path for SQLs in a package only if the access path data exists in the owner.PLAN_TABLE and the package is bound with EXPLAIN(YES).
With this enhancement, SYSVIEW for Db2 can now display the access path for static SQLs in a package that is bound with EXPLAIN(NO) or EXPLAIN(YES), even when the access path data is missing in the owner.PLAN_TABLE. For both of these scenarios, SYSVIEW for Db2 automatically performs an EXPLAIN PACKAGE statement and then retrieves the access path data for the display. This enhancement is beneficial to users who must know the access path regardless of the previous EXPLAIN setting.
This enhancement is available by applying PTF LU18340.
For more information about this enhancement, see New Features in the SYSVIEW for Db2 documentation.
-------------------------------------------