|
Problem IC84406
|
Status: Closed |
DB2 INSTANCE MAY CRASH IF IT RUNS OUT OF THE STATEMENT HEAP MEMORY |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
DB2 Instance may crash while compiling SQL statement if it runs
out of the statement heap memory.
Here are the example error messages in the db2diag.log and the
call stacks you might have seen.
1) The db2diag messages shows it ran out of the statement heap
memory.
2012-00-00-00.10.59.559211+540 E83622581A715 LEVEL: Warning
PID : 201118 TID : 73815 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-10974 APPID: AA1AAA7A.D20E.178815001107
AUTHID : DB200
EDUID : 73815 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloMemLogPoolConditions, probe:30
DATA #1 : <preformatted>
Out of memory failure for Statement Heap on node 0.
Requested block size : 4096 bytes.
Physical heap size : 393216 bytes.
Configured heap size : 41943040 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2) The call stacks may show below with remove_orphaned_boxes
function in the stacks.
sqloCrashOnCriticalMemoryValidationFailure
sqloCrashOnCriticalMemoryValidationFailure@glue6DB
sqlofmblkEx
sqlofmblkEx@glue7C4
drop__9sqlnq_ftbFP13sqlnq_memPool
box_drop_ts__9sqlnq_qtbFiN21
box_drop__9sqlnq_qtbFiT1
box_drop__9sqlnq_qtbFiT1@glueF5B
remove_orphaned_boxes__9sqlnq_qurFi
sqlnr_form_common_subexprs__FP9sqlnq_quriRi
sqlnr_optprep__FP9sqlnq_qur
sqlnr_optprep_action__FP10sqlnr_qrwaPiP14sqlnr_progress
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s@AF289_111
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
sqlnr_exe__FP9sqlnq_qur
sqlnr_exe__FP9sqlnq_qur@glue155E
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiPUl
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb
sqlra_get_var__FP8sqlrr_cbiT2bPbT5
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
.sqljsParse.fdpr.clone.280__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgentb
@64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T
RunEDU__8sqeAgentFv
EDUDriver__9sqzEDUObjFv
sqloEDUEntry |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB Version v10.1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 FixPack 1. *
**************************************************************** |
| Local Fix: |
Increase APPL_MEMORY and STMTHEAP to avoid out of statement heap
memory. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
05.11.2012
05.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
