home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 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 FixList