DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 fixpack 3                        * 
****************************************************************

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

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Fixed in DB2 version 10.1 fixpack 3

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95267 
follow-up : 

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

22.04.2013
11.11.2013
11.11.2013