|
Problem IC76524
|
Status: Geschlossen |
UNDER RARE CONDITIONS, THE QUERY COMPILER FAILS TO HANDLE AN OUT OF STMTHEAP CONDITION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in Version V9.7 Fix Pack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.05.2011
08.12.2011
08.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
