DB2 FOR LUW / DB2FORLUW / A50 - 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 to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or Later                                             * 
****************************************************************

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 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix 
Pack 4)

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

31.10.2013
13.10.2014
13.10.2014