DB2 FOR LUW / DB2FORLUW / 970 - DB2

An incorrect result set might be produced when INTRA_PARALLEL is 
enabled for a SQL statement if all of the following conditions 
are met: 
 
(a) the statement contains an OLAP function with a PARTITION BY 
and ORDER BY clause 
 
(b) the partition by clause contains all columns that derive 
from a scalar result that is guaranteed to return at most one 
value, such as the "select max(a) ma from t1" in the following 
example 
 
select rownumber() over (partition by tmp.ma order by t2.b) from 
(select max(a) ma from t1) tmp(ma), t2; 
 
(c) the query degree of the access plan is > 1

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 and Fix Pack 11                   * 
****************************************************************

To produce correct results, you can use the CURRENT DEGREE 
special register to set the degree of parallelism to 1.

Problem was first fixed in DB2 version 9.7 and Fix Pack 11

not known / see Local fix

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

11.12.2014
09.10.2015
09.10.2015

9.7.