DB2 - Problembeschreibung
Problem IC69340 | Status: Geschlossen |
DB2 MAY RETURN INCORRECT RESULTS WITH CORRELATED PREDICATE AND OLAP FUNCTIONS IN DPF MODE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
The incorrect results problem only happens in DPF mode. This problem occurs in a query that uses OLAP functions and uses a correlated predicate applied to the input to the OLAP functions. For example, select 1 from activity a, table(select p.actno, sum(emptime) over(partition by p.actno) time -- OLAP function from proj_act p left join emp_act e on p.projno = e.projno and a.actno = e.actno) e -- correlated predicate where a.actno=160 To verify that whether any query faces this problem or not, inspect the db2exfmt output of the query. The db2exfmt that shows the table being the parent table of the correlation (table activity in the example) is accessed under the processing of the OLAP function of the query. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 v9.5 fix pack 6 * **************************************************************** | |
Local-Fix: | |
Upgraded to DB2 version 9.5 Fix Pack 6. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
The fix was first introduced in DB2 v9.5 fix pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69398 IC69523 IC74790 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.06.2010 30.06.2010 30.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |