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

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC95267 
Nachfolger : 

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

22.04.2013
11.11.2013
11.11.2013