DB2 FOR LUW / DB2FORLUW / A10 - DB2

When STMTHEAP is automatic and memory is constrained, a memory 
allocation request to STMTHEAP can fail; but the next allocation 
request can succeed. The query compiler can fail to handle such 
a situation. When the problem is encountered, you can observe 
traps. 
 
An example trap is below 
 
sqlno_greedy_resume_part 
sqlno_greedy_next_part 
sqlno_crule_join 
sqlno_gen_partitions_for_QTB 
sqlno_plan_end_opr 
sqlno_each_opr 
sqlno_walk_qun 
sqlno_each_opr

The following can help to reduce the possibility of encountering 
the problem: 
 
1) set STMTHEAP to a fixed value 
2) allow room for STMTHEAP to grow by increasing APPL_MEMORY and 
INSTANCE_MEMORY

keiner bekannt / siehe Local-Fix

This APAR is a duplicate of IC83237

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

04.11.2012
17.11.2012
17.11.2012