ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Future EXPLAIN for unqualified table


Article ID: 50820


Updated On:


RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Fast Load for DB2 for z/OS Rapid Reorg for DB2 for z/OS



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


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.


Component: PPADB2