|
Problem IC89680
|
Status: Closed |
REDISTRIBUTE DOES NOT FREE UP DISK SPACE FOR INDEX OBJECTS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The REDISTRIBUTE operation (with NOT ROLLFORWARD RECOVERABLE and
INDEXING MODE REBUILD options) does not free up physical disk
space occupied by index objects on "sender" partitions, even
though some of the index info that were occupying disk space had
now been moved (redistributed) to other partitions. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.7 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
reorg or rebuild the indexes after redistribute |
| available fix packs: |
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 |
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.01.2013
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
