home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75715 Status: Closed

TRAP DURING REDISTRIBUTE ON AN MDC TABLE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of Redistribute utility                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5 FP8                                      * 
****************************************************************
Local Fix:
Issue a REDISTRIBUTE CONTINUE command.
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Solution
Fixed in DB2 V9.5 FP8
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.04.2011
30.06.2011
30.06.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList