DB2 - Problembeschreibung
Problem IC61611 | Status: Geschlossen |
DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF THE JOIN OPERATION FOR INCREMENTAL MQT MAINTENANCE IN DPF | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
DB2 SQL Query Optimizer has improved the performance of the join operation for incremental maintenance of a materialized query table (MQT) when all of the following conditions are satisfied: (1) it is a partitioned (DPF) environment (2) the SQL statement being compiled contains more than one modifying operation (i.e. INSERT/UPDATE/DELETE) on the base tables of an MQT (call it S1) (3) S1 is a refresh immediate MQT (4) a. S1 is a replicated MQT OR b. S1 is an MQT with no group-by expression OR c. S1 is an MQT with group-by expression but none of the group-by columns is updated by the SQL statement Example: Assuming a DPF environment, and base table (base1) has immediate MQT (S1) that satisfies conditions (3) and (4) above, here is an example of the SQL statement mentioned in condition (2): begin atomic insert into base1 values (1,1);-- update base1 set i2 = i2 + 1;-- end; | |
Problem-Zusammenfassung: | |
Fixed in V97fp1 | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.06.2009 21.12.2009 21.12.2009 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |