How does PPA determine which plan_table to access during explain processing?

Document ID : KB000014200
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How does PPA determine which plan_table to access during explain processing? 

Answer:

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

 

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