DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under certain scenario, DB2 might produce incorrect results if 
the following conditions are true: 
1. The query contains an exists subquery 
2. The subquery has a fetch first n rows clause in the outer 
most subselect 
3. There is either a LOB column or a total column column width > 
32K in the query output list. 
 
Eg.: 
select P.lob 
from P 
where exists (select 1 from SQ where SQ.c1 = P.c1 fetch first 1 
rows only);

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 970 fix pack 9                        * 
****************************************************************

1. Remove fetch first n rows clause 
2. Add order by clause to the subquery.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Please upgrade to DB2 version 970 fix pack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91798 IC91812 IC95426 
follow-up : 

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

18.03.2013
13.01.2014
13.01.2014

9.0.,
9.7.0