|
Problem IC76524
|
Status: Closed |
UNDER RARE CONDITIONS, THE QUERY COMPILER FAILS TO HANDLE AN OUT OF STMTHEAP CONDITION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Under rare conditions, during query compilation, the query
compiler fails to handle an out of STMTHEAP condition. When the
problem is encountered, you might observe one of the following
outcomes:
1. A trap in function sqlno_iext_idx_search_method, or
sqlno_find_key_preds with a stack of:
sqlno_iext_idx_search_method
sqlno_find_key_preds
sqlno_btree_preds
sqlno_index_scan
sqlno_crule_index_scan
...
sqlno_top_qtb
sqlno_each_qur
sqlno_scan_qgm
sqlno_planning_scan
sqlno_planning_phase
sqlno_exe
sqlno_exe
sqlnn_cmpl
2. An error sqlcode -901. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version V9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
The likelihood of experiencing this problem is increased if the
STMTHEAP database configuration parameter is set to AUTOMATIC (a
feature available in DB2 starting with V9.5). If this is the
case, modify STMTHEAP to a manual value without the AUTOMATIC
attribute. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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
|
| Solution |
First fixed in Version V9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.05.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
