|
Problem IC72072
|
Status: Closed |
HEALTH MONITOR CRASHES WHEN AUTOMATIC STATISTICS PROFILING ( AUTO_STATS_PROF) IS SET TO ON. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* User having Automatic Statistics Profiling set to ON *
****************************************************************
* PROBLEM DESCRIPTION: *
* HEALTH MONITOR CRASHES WHEN AUTOMATIC STATISTICS PROFILING *
* (AUTO_STATS_PROF) IS SET TO ON. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack for DB2 V9.1 *
**************************************************************** |
| Local Fix: |
Disable AUTOMATIC STATISTICS PROFILING i.e. set
AUTO_STATS_PROF=OFF |
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
fixed in later versions of DB2 V9.1fp8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.10.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.,
9.1.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
