|
Problem IC69643
|
Status: Closed |
HEALTH MONITOR CRASHES WHEN AUTOMATIC STATISTICS PROFILING ( AUTO_STATS_PROF) IS SET TO ON. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
When Automatic Statistics Profiling is enabled on the system ,
it causes the Health Monitor to crash and generates the
following stack:
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000000056E38 leftmost + 0x8
0x0900000000059000 malloc_y + 0x514
0x0900000000055EC8 malloc_common_79_63 + 0x14
0x0900000000AADF14 sqlo_malloc + 0x8
0x0900000000AAC860 sqloGetUserAttribById + 0x7C
0x0900000000AACAF8 sqloGetRealUsername + 0x2C
0x0900000000AB912C sqleUCappConnect + 0x540
0x0900000000CE0A28
CLI_sqlConnect__FP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERINFO
+ 0x5AC
0x0900000000D21BA4
SQLConnect2__FP15CLI_CONNECTINFOPUcsT2T3T2T3T2T3Uc + 0x8
0x090000000104E5C4
SQLDriverConnect2__FP15CLI_CONNECTINFOPvPUcsT3T4PsUsUcT9P19CLI_E
RRORHEADERINFO
+ 0x468
0x0900000000E72D2C SQLConnect1__FP15CLI_CONNECTINFOPUcsT2T3T2T3
+ 0x328
0x0900000000E65474 SQLConnect + 0x520
0x090000000760C604 hmonSQLConnect__FiPUcsT2T3T2T3 + 0x2F0
0x09000000076AEA84
serverConnect__26FeedbackWarehousePopulatorFbP10HiCallback +
0x1C0
0x09000000076B5E48 hleoFwPopulate__FP11FwPopParams + 0x548
0x09000000076ACFE4 hmonLEOExecStatsProfiling + 0x140
0x090000000767686C runAPI__17hmonJobExecThreadFP11jobExecNode +
0x23C
0x09000000076763A4 run__17hmonJobExecThreadFv + 0x2F4
0x0900000007605AA8 entryPoint__10hmonThreadFPv + 0x44
0x09000000076061A4 hmonThreadWrapper__FPv + 0x240
0x09000000005F24F4 _pthread_body + 0xDC
</StackTrace>
The crash is due to memory corruption in LEO. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Customers on DB2 V9.1.x , DB2 V9.5.x and DB2 V9.7 GA *
****************************************************************
* PROBLEM DESCRIPTION: *
* Health monitor crashes , which in turn leads to instance *
* crash if Health monitor doesn't restart *
****************************************************************
* RECOMMENDATION: *
* Upgrade to next release of V9.1 *
**************************************************************** |
| Local Fix: |
Disable AUTOMATIC STATISTICS PROFILING i.e. set
AUTO_STATS_PROF=OFF |
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Fixed in future releases |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72071 IC72072 IC72073
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.07.2010
14.06.2011
14.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
