DB2 FOR LUW / DB2FORLUW / 970 - DB2

If MQT is defined as "SELECT * FROM <view_name>", this MQT is 
supposed to be identified as view MQT. A view MQT may replace a 
view referenced by the query, and thus the query may scan the 
MQT rather than recompute the view from base tables. An MQT can 
specify MDC (Multidimensional Clustering) defined in the MQT 
creation ddl. The MDC, however, prevents MQT from being treated 
as view MQT. As result, the view MQT with MDC may not replace 
the query referenced view although that is expected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on all DB2 V9.7 FP5 and under.                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* MQT CAN NOT BE RECOGNIZED AS VIEW MQT WHEN IT HAS MDC        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to at least DB2 V9.7 FP6 at a minimum to get  * 
* this fix.                                                    * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 V9.7 FP6.

keiner bekannt / siehe Local-Fix

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

12.09.2011
25.06.2012
25.06.2012

9.7.FP6