Future EXPLAIN for unqualified table

Products

• 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
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

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?

Solution:

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.

Environment

Release:
Component: PPADB2