DB2 FOR LUW / DB2FORLUW / A10 - DB2

A query that has a very large number of parameter markers in an 
IN LIST may hang during query compilation. 
 
For example: 
    select * from T where C1 in (?,?,?,...)

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version v10.1 fixPack 3                   * 
****************************************************************

Rewrite the IN LIST to use a subselect: 
    select * from T where C1 in ( select cast( val as <type> ) 
from ( values ?,?,?,... ) inlist(val)

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
 

Upgrade to DB2 LUW version v10.1 fixPack 3

keiner bekannt / siehe Local-Fix

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

21.04.2013
11.11.2013
11.11.2013