|
Problem IC70649
|
Status: Geschlossen |
GUIDELINE MAY NOT BE APPLIED WHEN MQT USAGE IS ENFORCED USING A PROFILE OR DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
An optimizer plan guideline provided in an optimizer profile may
not be applied if MQT usage enforcement is enabled.
MQT usage enforcement can be enabled in one of 2 ways:
- Using the FORCE_REPLICATED_MQT_MERGE option of the
DB2_EXTENDED_OPTIMIZATION registry variable (for replicated
tables)
- In an optimizer profile using the <MQTENFORCE> element
Specifically, for this issue to arise, following conditions must
be satisfied:
- MQT usage enforcement must be enabled
- One or more tables referenced by the query must have dependent
MQTs defined on them
- The dependent MQTs can be matched semantically to the
referenced based tables
- Said tables must be referenced in the access plan guideline in
an active optimizer profile by any of the elements listed under
the "accessRequest" group in the CURRENT OPTIMIZATION PROFILE
SCHEMA. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 4 or later. *
**************************************************************** |
| Local-Fix: |
None exists, aside from either turning off MQT usage enforcement
or by not issuing a guideline. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
|
| Lösung |
First fixed in DB2 Version 9.7 Fix Pack 4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.08.2010
28.04.2011
28.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
