How to use “package” access path information to solve a real-life application issue!
The new SQL EXPLAIN statement options!
There are NEW (as of Db2 for z/OS V10) SQL “EXPLAIN” statement options to get the hidden details of the actual access path instructions from the actual package (which is actually used at run time) and stuff that impossible-to-read package instruction “explanation” into the friendly-to-read PLAN_TABLE!
- And then you can query the PLAN_TABLE and understand what is going on!
Click here to read the full article. (IDUG login required).