DB2 FOR LUW / DB2FORLUW / 950 - DB2

DB2 compiler attempts to match query with all of the MQT and 
statview (statistical view) that depends on query referenced 
base table or nickname.  All of the MQT and statview are 
supposed to be present in catalog table sysibm.systables. In 
case an MQT or statview is attempted to match to query but it 
has no catalog row, the query compilation used to disable MQT 
matching.   The following message is displayed in the db2exfmt 
extended diagnostic for the query: 
 
Diagnostic Details: 
     EXP0080W  The current usage of the statement or the 
     statement containing update, delete or insert or 
     constructs like sampling limits MQT matching. 
 
With this fix, the remaining MQT and statview are still matched 
to the query, and the unexpected MQT or statview is ignored by 
matching and a corresponding EXP0058W diagnostic message will 
capture its schema and name.

**************************************************************** 
* USERS AFFECTED:                                              * 
* General environment                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.5.fp10                                         * 
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.04.2012
27.08.2012
27.08.2012

9.5.FP10