Future EXPLAIN for unqualified table

book

Article ID: 50820

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA 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