DB2 - Problembeschreibung
Problem IC81431 | Status: Geschlossen |
DB2 INSTANCE MAY CRASH IF IT RUNS OUT OF THE STATEMENT HEAP MEMORY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fixpack 6 or later. * **************************************************************** | |
Local-Fix: | |
Increase APPL_MEMORY and STMTHEAP to avoid out of statement heap memory. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in Version 9.7 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84406 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.02.2012 14.06.2012 14.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |