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 IC75285 Status: Geschlossen

TRAP DURING REDISTRIBUTE ON AN MDC TABLE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
During redistribution of an MDC table it is possible 
redistribute traps. 
 
The db2diag.log will have an entry similar to: 
 
2010-06-24-03.52.37.811838-240 I47542751A1762     LEVEL: Severe 
PID     : 155970               TID  : 15011       PROC : db2sysc 
220 
INSTANCE: bcuaix               NODE : 220         DB   : VLDB 
APPHDL  : 0-303                APPID: *N0.DB2.100624004151 
AUTHID  : BCUAIX 
EDUID   : 15011                EDUNAME: db2rcont 220 
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 
0x07000000d856f0e0 
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 
0x07000000D856F0C8 : FAB0 7000 000D 8560 2934 9619 008C FB2B 
..p....`)4.....+ 
0x07000000D856F0D8 : FAB0 7000 000D 8560 
..p....` 
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 
0x07000000D856F0E0 : 0900 1000 A0C4 FD50 0000 0000 0000 0000 
.......P........ 
0x07000000D856F0F0 : 0700 0000 D856 F0E0 0900 1000 A0C4 FDB8 
.....V.......... 
0x07000000D856F100 : 0000 0000 0000 0000 0700 0000 C987 91A0 
................ 
CALLSTCK: 
  [0] 0x09000000018634DC pdLog + 0xF8 
  [1] 0x0900000001B2613C 
@79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x14C 
  [2] 0x0900000001921EF4 sqlofmblkEx + 0x58 
  [3] 0x0900000000FEB99C zTrimToSize__22sqlucCDoublyLinkedListFv 
+ 0x124 
  [4] 0x0900000001D6AF5C zCleanUp__22sqlucCDoublyLinkedListFv + 
0xB4 
  [5] 0x0900000002EDE1A8 zCleanUp__15sqlucCHashTableFv + 0xD0 
  [6] 0x0900000001D824B0 zCleanUp__19sqlurCObjectManagerFv + 
0x430 
  [7] 0x0900000002F37088 zCleanUp__23sqlurCObjectManagerListFv + 
0x498 
  [8] 0x09000000041D7104 
zCleanUpTableCBs__27sqlurCSourceTargetPartitionFv + 0x1B4 
  [9] 0x09000000041D5AE4 
zCleanUp__27sqlurCSourceTargetPartitionFv + 0xE8 
 
This APAR only affects MDC tables.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of Redistribute                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP5.                                      * 
****************************************************************
Local-Fix:
Issue a REDISTRIBUTE CONTINUE command.
verfügbare FixPacks:
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 DB2 V97 FP5
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75715 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.03.2011
09.12.2011
09.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList