DB2 - Problembeschreibung
Problem IC80809 | Status: Geschlossen |
DB2 CAN TRAP IN SQLODIAGNOSEFREEBLOCKFAILURE WHEN USING 2 PHASE COMMIT. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
db2 can trap in SQLODIAGNOSEFREEBLOCKFAILURE when using 2 phase commit. You can find the following entry in db2diag.log. 2009-11-03-18.28.55.241653-300 I29082A1746 LEVEL: Severe PID : 1237220 TID : 6942 PROC : db2sysc INSTANCE: svtdbm10 NODE : 000 DB : SDBS APPHDL : 0-118 APPID: *LOCAL.svtdbm10.091103215453 AUTHID : SVTDBM10 EDUID : 6942 EDUNAME: db2agent (SDBS) FUNCTION: DB2 UDB, SQO Memory Management, sqloDiagnoseFreeBlockFailure, probe:10 MESSAGE : Possible memory corruption detected. DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes 0x820F0002 DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8 bytes 0x0780000000d53cc0 DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 0x0780000000D53CA8 : FAB0 7800 0000 0D50 0780 0000 00D5 31C8 ..x....P......1. 0x0780000000D53CB8 : 0780 0000 00D5 5568 ......Uh DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 0x0780000000D53CC0 : 0000 0000 0000 0360 0000 0000 0000 0009 .......`........ 0x0780000000D53CD0 : 0000 0000 0000 0000 0000 0001 0000 0000 ................ 0x0780000000D53CE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ CALLSTCK: [0] 0x090000001203CEE8 sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0xE8 [1] 0x090000001203CD40 sqlofmblkEx + 0x780 [2] 0x0900000012773514 __dl__10sqm_objectFPv + 0x14 [3] 0x090000001229B8A0 __dt__11sqlmon_stmtFv + 0x380 [4] 0x0900000012292E68 cleanup_sqlmon_conn__11sqlmon_connFv + 0x448 [5] 0x0900000014E02CFC sqlm_a_exit__FP8sqeAgent + 0x5BC [6] 0x09000000126AE96C AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x136C [7] 0x0900000012069EBC sqlesrspWrp__FP14db2UCinterface + 0x9C [8] 0x0900000012067508 sqleUCagentConnectReset + 0xE8 [9] 0x09000000132383D0 sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x1F0 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Recommended to upgrade to DB2 for LUW version 9.5 fixpack 10 * **************************************************************** | |
Local-Fix: | |
Lösung | |
fix available in DB2 for LUW version 9.5 fixpack 10 onwards. | |
Workaround | |
NA | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.01.2012 17.06.2013 17.06.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |