|
Problem IC72072
|
Status: Geschlossen |
HEALTH MONITOR CRASHES WHEN AUTOMATIC STATISTICS PROFILING ( AUTO_STATS_PROF) IS SET TO ON. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| verfügbare FixPacks: |
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
|
| Lösung |
fixed in later versions of DB2 V9.1fp8 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.10.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.,
9.1.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
