|
Problem IC67287
|
Status: Closed |
INSTANCE MY CRASH WHEN STATEMENT MONITOR IS ON AND GET SNAPSHOT FOR DYNAMIC SQL, BECAUSE MON_HEAP_SZ DBM CFG IS SMALL. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2010
30.06.2010
30.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP*,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
