How to find Missing Db2 for z/OS static SQL access path information from PLAN_TABLE?

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).

Recent Stories
July Spotlight – Db2 LUW: Types of I/O

Db2 Location Statistics Traces for Remote Applications

Machine Learning with IBM Db2: Building and Deploying a Linear Regression Model