DB2 FOR LUW / DB2FORLUW / 950 - DB2

A query might produce incorrect results under the following 
scenario: 
 
1. The environment is a multi-partition DPF setup. 
2. There is a view which references one or more replicated MQTs 
   directly. 
3. The view is used in the context of an existential subquery. 
4. (Optional) if replicated table is maintained by user, there 
   does not exist a unique index 
 
Example: 
 
create table t1(c1 int, c2 int); 
 
create table t2(c1 int, c2 int); 
 
create table repl_mqt as (select * from t2) data initially 
deferred refresh deferred distribute by replication; 
 
create view v1 as (select * from repl_mqt); 
 
select * from v1 where v1.c2 in (select c2 from t1);

Originally fixed in V9.5 Fixpack 9.

The view should reference the base table instead of the 
replicated MQT directly.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Originally fixed in V9.5 Fixpack 9.

not known / see Local fix

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

30.11.2011
13.03.2012
13.03.2012

9.5.FP9