DB2 FOR LUW / DB2FORLUW / A10 - DB2

You might encounter large statement heap usage, which can 
produce an SQL0101N error or SQL0437W warning, when compiling a 
SQL statement with a large number of joins between tables 
partitioned by range.  This problem can occur when the joins 
reference the range partitioning key and there are also 
predicates that equate the key to a constant, such as 
DP_KEY_COLUMN = 'Y'.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Table partitioning data organization                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* You might encounter large statement heap usage, which can    * 
* produce an SQL0101N error or SQL0437W warning, when          * 
* compiling a SQL statement with a large number of joins       * 
* between tables partitioned by range.  This problem can occur * 
* when the joins reference the range partitioning key and      * 
* there are also predicates that equate the key to a constant, * 
* such as DP_KEY_COLUMN = 'Y'.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10 Fix Pack 1 or later release        * 
* containing the fix.                                          * 
****************************************************************

You could try to make the predicates look complex to prevent the 
compiler generate join predicates. For example, modify predicate 
DP_KEY_COLUMN = 'Y' to  DP_KEY_COLUMN || '' = 'Y'.  However, 
this will prevent it from consideration as an index range 
delimiting predicate and for data partition elimination, and the 
query runtime 
performance may be affected.

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 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
 

The problem was fixed in DB2 Version 10 Fix Pack 1

See Local Fix

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

14.06.2012
03.06.2013
03.06.2013