Future EXPLAIN for unqualified table within Plan Analyzer.

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

A future Explain for a package that had unqualified tables was executed, the target subsystem was different that the source. Plan Analyzer for Db2 for z/OS (PPA) 
was able to determine the correct qualifier to use. No value was specified in the SQL qualifier panel. How is that possible?

Resolution

Explain will use the qualifier from SYSPACKAGE or SYSPLAN for catalog SQL Unless the user has requested through explain option
SQL qualifier override that another qualifier be used instead for all unqualified objects.