|
Problem IT06937
|
Status: Closed |
Query referring to the complex views can return SQL101N |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Set registry variable DB2_REDUCED_OPTIMIZATION=NO_PEA |
| Solution |
First Fixed in DB2 10.5 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2015
09.05.2017
09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
