|
Problem IC78612
|
Status: Closed |
MQT CAN NOT BE RECOGNIZED AS VIEW MQT WHEN IT HAS MDC |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 V9.7 FP6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.09.2011
25.06.2012
25.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
