DB2 FOR LUW / DB2FORLUW / A10 - 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 V10.1 Fix Pack 4              * 
****************************************************************

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 )

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem was first fixed in V10.1 Fix Pack 4

not known / see Local fix

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

31.10.2013
26.06.2014
26.06.2014