DB2 - Problem description
Problem IC87837 | Status: Closed |
DB2 QUERY COMPILER CAN TRAP WHEN STMTHEAP is AUTOMATIC AND MEMORY is CONSTRAINED | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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 | |
Problem Summary: | |
Local Fix: | |
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 | |
Solution | |
Workaround | |
not known / see Local fix | |
Comment | |
This APAR is a duplicate of IC83237 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.11.2012 17.11.2012 17.11.2012 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |