home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList