DB2 FOR LUW / DB2FORLUW / 970 - DB2

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;

Fixed in V97fp1

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
 

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.06.2009
21.12.2009
21.12.2009