|
Problem IC79645
|
Status: Closed |
REDISTRIBUTE CAN INCORRECTLY UPDATE CATALOG TABLES ABOUT DATABASE PARTITION GROUPS ADDED BUT NOT IN USE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When redistributing using a target map the redistribute command
can incorrectly update the SYSCAT.DBPARTITIONGROUPDEF view.
This problem only affects redistribute with a target partition
map. Redistribute marks any database partitions which are added
but not in use and not in the target partition map as in use
after the redistribute command finishes, even though no data is
moved to these database partitions.
The IN_USE field of SYSCAT.DBPARTITIONGROUPDEF will be changed
from 'A' to 'Y'. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of redistribute with a target partition map. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 V9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.11.2011
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
