Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC67278 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 / 950 - 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.Upgrade to DB2 Version 9.5 Fix Pack   * 
* 6.                                                           * 
****************************************************************
Local Fix:
Increase the MON_HEAP_SZ Database Manager configuration 
parameter.
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.5 Fix Pack 6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC67287 
follow-up : 
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.5.,
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.