|
Problem IC75285
|
Status: Closed |
TRAP DURING REDISTRIBUTE ON AN MDC TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97 FP5. *
**************************************************************** |
| Local Fix: |
Issue a REDISTRIBUTE CONTINUE command. |
| available fix packs: |
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
|
| Solution |
Fixed in DB2 V97 FP5 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75715
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.03.2011
09.12.2011
09.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
