How does Plan Analyzer determine which plan_table to access during explain processing

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

How does Plan Analyzer for Db2 for z/OS (PPA) determine which plan_table to access during explain processing.

Resolution

For CURRENT explains, PPA will search for a row in creator.plan_table where creator = sysplan.CREATOR (for PLANS and DBRMS) or syspackage.owner (PACKAGES). 

For FUTURE explains, PPA will update creator.plan_table where creator is equal to the SET CURRENT register in Db2, that is the SECONDARY ID.
This is always equal to the logon ID (primary) until a SET CURRENT changes it. (Manipulated in PPA via the SECAUTH explain option.)