DB2 FOR LUW / DB2FORLUW / A50 - DB2

Query can hit sql -101 error message. Setting the statement heap 
to automatic would not help much as query rewrite would keep 
doing join enumeration and exhaust statement heap by increasing 
the compile time . The issue is caused when there are 
aggregation above many level of complex views that contain large 
expressions, such as case statements and the result of those 
case expressions feed into two or more of the aggregations 
function.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fix Pack 7                               * 
****************************************************************

Set registry variable DB2_REDUCED_OPTIMIZATION=NO_PEA

First Fixed in DB2 10.5 Fix Pack 7

keiner bekannt / siehe Local-Fix

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

03.02.2015
09.05.2017
09.05.2017