|
Problem IC79863
|
Status: Geschlossen |
DB2 MAY ABEND WHEN THERE ARE MULTIPLE REPLICATED MQT AND FORCE_REPLICATED_MQT_MERGE IS SET |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When the following conditions are all met, compiling a query or
modifying statement may trap with stack:
sqlnq_qtboprparent::op
sqlnq_mch::is_maximal
sqlnq_som::compute_matchinfo_opt
sqlnr_compute_matchinfo
sqlnr_optprep
sqlnr_optprep_action
(1) There are at least two replicated MQT (Materialized Query
Table) and at least one non-replicated optimizer MQT or
statistical view. An optimizer MQT is such MQT whose definition
is simply "SELECT <expression list> FROM <one or more base
tables> WHERE <predicates>".
(2) Registry variable DB2_EXTENDED_OPTIMIZATION includes flag
FORCE_REPLICATED_MQT_MERGE.
(3) The query statement itself contains multiple subqueries, or
the modifying statement's target table has multiple enforced
checking constraint defined. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 9 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
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Fixed on DB2 Version 9.7 Fix Pack 6. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.11.2011
26.04.2012
26.04.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.9
|
 |
| 9.7.0.6
|
|
