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