|
Problem IC71577
|
Status: Closed |
REDISTRIBUTE CONTINUE OR ABORT ON LARGE RANGE PARTITIONED TABLES MAY HANG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Redistribute continue or redistribute abort on large range
partitioned tables may appear to hang. db2 list utilities show
detail will not show any progress for the redistribute
operation.
When dumping stacks it will show that one or more of the
redistribute agents are working on processing the control files,
with a stack similar to:
_ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup
+ 0x0057
sqlofmblkEx + 0x0252
_Z9sqlofmblkPv + 0x0006
sqlucCObjectdlEPv + 0x0006
sqlucCRBTree::TrimFreeRBNodeList
sqlucCRBTree::zRecycleRBNode
sqlucCRBTree::zRBTreeDelete
sqlucCRBTreeIterator::zRemove
sqlucCRBTreeIterator::zRemove
sqlucICollection::zEmptyThis
sqlurNextControlFileCleanUp
sqlurCControlFile::zGetRecieverRecoveryList
sqlurReceiverRecoverObject
sqlurReceiverRecover
sqlurControllerRecover
sqlurCControllerSubAgent::iRun |
| Problem Summary: |
|
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 |
First fixed in DB2 version 9.7 Fix Pack 4. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72827 IC72834
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.09.2010
29.04.2011
14.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
