DB2 FOR LUW / DB2FORLUW / 970 - DB2

In certain complex conditions using the Data Partition Feature 
(DPF), replicated MQTs 
are not exploited to improve performance of queries. 
 
The Extended Explain Information section of the db2exfmt output 
may show : 
 
Diagnostic Identifier:  2 
Diagnostic Details:     EXP0062W  The following MQT or 
statistical view was 
            not eligible because one or more columns or 
expressions referenced in the query were not found 
            in the MQT: "<schema>"."<replicated mqt name>". 
 
 
The following is an example of the conditions required for this 
problem: 
1. Queries contain EXISTS or IN subquery in the predicates, 
2. The objects outside of the subquery in the queries are 
complex views, 
3. The complex views reference tables in which there are 
replicated MQTs 
   defined for those tables.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to v9.7 Fix Pack 10 or above     * 
****************************************************************

Rewrite the subquery to a semantic equivalent using GROUP BY 
clause 
e.g. 
IN ( SELECT DISTINCT COL  FROM BASETABLE  ) 
can be rewritten to : 
 
IN ( SELECT COL FROM BASETABLE GROUP BY COL )

This problem was first fixed in v9.7 Fix Pack 10

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97348 IC97349 
follow-up : 

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

30.09.2013
08.12.2014
08.12.2014

9.7.FP10