DB2 FOR LUW / DB2FORLUW / A50 - DB2

A complex query with an OLAP specification and a sub-query might 
return extra rows. 
 
Example of an OLAP query: 
select c18,c1a,c1f,c15,c16  from mytbrow1 where (c15, c16) in 
(select min(c25) over (partition by c27, c2b order by c2c, c2h, 
c20 rows between unbounded preceding and current row) as min, 
c36 from  mytbrow2, mytbrow3 where mytbrow1.c14 = mytbrow2.c24 
and mytbrow2.c21 = mytbrow3.c31) order by c18, c1a, c1f; 
 
Internal information about the query needs to be reviewed by DB2 
support to confirm that the query is not affected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.6.                             * 
****************************************************************

The problem is first fixed in DB2 version 10.5.0.6.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.02.2015
14.08.2015
19.08.2015