DB2 FOR LUW / DB2FORLUW / 970 - 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 version 9.7 fix pack 8                        * 
****************************************************************

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 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

First fixed in DB2 version 9.7 fix pack 8

keiner bekannt / siehe Local-Fix

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

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

19.11.2012
04.04.2013
04.04.2013

9.7.FP8