|
Problem IC72827
|
Status: Closed |
REDISTRIBUTE CONTINUE OR ABORT ON LARGE RANGE PARTITIONED TABLES MAY HANG |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: |
Added closing code. |
| Local Fix: |
|
| 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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.11.2010
30.06.2011
30.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
