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
Anomaly Detection in Python and SQL (part 2)

Db2 Client Packages

INDEX COMPRESSION in Db2 Z, A recap and overview!