home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC76523 Status: Geschlossen

UNDER RARE CONDITIONS, THE QUERY COMPILER FAILS TO HANDLE AN OUT OF
STMTHEAP CONDITION

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - 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 
 ... 
 
2. A trap in function sqlno_int_order_arrange_grby_ord with a 
stack like: 
sqlno_int_order_arrange_grby_ord 
sqlno_plan_begin_opr 
sqlno_each_opr 
sqlno_walk_qun 
... 
 
3. A trap in function sqlno_int_order_opr_req with a stack like: 
sqlno_int_order_opr_req 
sqlno_int_order_get_qtb 
sqlno_int_order_scan or sqlno_int_order_get_qun 
... 
 
4. A trap in function sqlno_itr_keycond::next with a stack like: 
sqlno_itr_keycond::next 
sqlno_eiscan_plan 
 
5. A trap in function sqlno_dpart_elim_keys with a stack like: 
sqlno_dpart_elim_keys 
sqlno_dpart_elim_gen_keys 
sqlno_dpart_elim_compute 
... 
 
6. Very rarely, an error sqlcode -901.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 LUW users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 9 or later.              * 
****************************************************************
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.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in Version 9.5 Fix Pack 9.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC76524 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.05.2011
14.03.2012
14.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.,
9.5.,
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList