DB2 - Problembeschreibung
Problem IC67287 | Status: Geschlossen |
INSTANCE MY CRASH WHEN STATEMENT MONITOR IS ON AND GET SNAPSHOT FOR DYNAMIC SQL, BECAUSE MON_HEAP_SZ DBM CFG IS SMALL. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Instance may crash with the following stacks when the statement monitor is on and get snapshot for dynamic sql, meanwhile the value of the DBM configuration MON_HEAP_SZ is small. <StackTrace> -------Frame------ ------Function + Offset------ 0x0900000029C2632C traverse__18sqlqg_remote_stmtsFP24sqlqg_remote_stmt_status + 0x14C 0x090000001034880C sqm_load_remote_stmt__FP16sqeLocalDatabaseP19sqm_snapshot_buffer P16sqlm_header_infoT3UiP16sqm_agent_entity + 0x22C 0x0900000010328654 sqlmw_dyn_sql__FP16sqeLocalDatabaseP19sqm_snapshot_bufferP16sqlm _header_infoUiP16sqm_agent_entity + 0xD4 0x0900000010335D34 sqlmonssagnt__FUi13sqm_entity_idP6sqlmaiT1PvP14sqlm_collectedUsT 7P5sqlca + 0x1334 0x09000000105CA014 sqlmonssbackend__FP12SQLE_DB2RA_T + 0xB94 0x090000000FDE5380 sqlesrvr__FP14db2UCinterface + 0x1A80 0x090000000FE18718 sqleMappingFnServer__FP5sqldaP5sqlca + 0xFF8 0x090000001055714C sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5 sqlca + 0x140C 0x0900000010515BF4 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x1554 0x0900000015515438 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x458 0x09000000154DDDB8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x1D8 0x09000000154DCD34 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4 0x09000000154CB6EC sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x3EC 0x09000000154CCD5C sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C 0x09000000154D2B2C sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC 0x09000000154D3F04 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x264 0x090000000FBB476C RunEDU__8sqeAgentFv + 0x3AC 0x090000000F635378 EDUDriver__9sqzEDUObjFv + 0x138 0x090000000F63557C sqlzRunEDU__FPcUi + 0x3C 0x090000000F449B9C sqloEDUEntry + 0x67C </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Unknown * **************************************************************** * PROBLEM DESCRIPTION: * * Instance may crash with the following stacks when * * thestatementmonitor is on and get snapshot for dynamic sql, * * meanwhilethevalue of the DBM configuration MON_HEAP_SZ is * * small.<StackTrace>-------Frame------ ------Function + * * Offset------0x0900000029C2632Ctraverse__18sqlqg_remote_stmtsFP * +0x14C0x090000001034880Csqm_load_remote_stmt__FP16sqeLocalData * 0x22C0x0900000010328654sqlmw_dyn_sql__FP16sqeLocalDatabaseP19s * 0xD40x0900000010335D34sqlmonssagnt__FUi13sqm_entity_idP6sqlmai * 0x13340x09000000105CA014 sqlmonssbackend__FP12SQLE_DB2RA_T + * * 0xB940x090000000FDE5380 sqlesrvr__FP14db2UCinterface + * * 0x1A800x090000000FE18718 * * sqleMappingFnServer__FP5sqldaP5sqlca * * +0xFF80x090000001055714CsqlerKnownProcedure__FiPcPiP5sqldaT4P1 * 0x140C0x0900000010515BF4sqlerCallDL__FP14db2UCinterfaceP9UCstp * +0x15540x0900000015515438sqljs_ddm_excsqlstt__FP14db2UCinterfa * +0x4580x09000000154DDDB8sqljsParseRdbAccessed__FP13sqljsDrdaAs * 0x1D80x09000000154DCD34sqljsParse__FP13sqljsDrdaAsCbP14db2UCin * + 0x1F40x09000000154CB6EC * * sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb+0x3EC0x09000000154CC * + * * 0x15C0x09000000154D2B2CsqljsDrdaAsInnerDriver__FP18SQLCC_INITS * + 0x2EC0x09000000154D3F04 * * sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T+0x2640x090000000FBB4 * RunEDU__8sqeAgentFv + 0x3AC0x090000000F635378 * * EDUDriver__9sqzEDUObjFv + 0x1380x090000000F63557C * * sqlzRunEDU__FPcUi + 0x3C0x090000000F449B9C sqloEDUEntry + * * 0x67C</StackTrace> * **************************************************************** * RECOMMENDATION: * * Increase the MON_HEAP_SZ Database Manager * * configurationparameter orUpgrade to DB2 Version 9.7 Fix Pack * * 2. * **************************************************************** | |
Local-Fix: | |
Increase the MON_HEAP_SZ Database Manager configuration parameter. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 2. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.03.2010 30.06.2010 30.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP*, 9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |