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 IC80101 Status: Geschlossen

QUERY USING A VIEW BASED ON REPLICATED MQT IN CONTEXT OF EXISTENTIAL
SUBQUERY MAY RETURN INCORRECT RESULTS

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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);
Problem-Zusammenfassung:
Originally fixed in V9.5 Fixpack 9.
Local-Fix:
The view should reference the base table instead of the 
replicated MQT directly.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Originally fixed in V9.5 Fixpack 9.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.11.2011
13.03.2012
13.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList