DB2 FOR LUW / DB2FORLUW / 950 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 LUW users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 9 or later.              * 
****************************************************************

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.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in Version 9.5 Fix Pack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC76524 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.05.2011
14.03.2012
14.03.2012

9.0.,
9.5.,
9.5.FP9