DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a federated scenario with 2 DB2 LUW databases a UNION of 
SELECT on nicknames with fetch first n row clause could return 
incorrect results. 
 
The problem could be hit when following conditions are met: 
 
1) There is a UNION in the query 
2) The UNION has two or more SELECT branches which queries data 
from nicknames of one same server. 
3) One of the SELECT has Fetch First N Rows Only clause 
 
The fetch first n rows clause could be missing during query 
processing resulting in incorrect result. E.g. 
 
(SELECT * from nickname1 order by c1 fetch first 10 rows only) 
UNION (SELECT * from nickname2 order by c1 fetch first 10 rows 
only) 
 
With this problem, the result of the query could be larger than 
20 records.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10.                      * 
****************************************************************

First fixed in DB2 Version 9.7 Fix Pack 10.

not known / see Local fix

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

22.05.2014
17.11.2014
17.11.2014

9.7.FP10