DB2 - Problem description
Problem IC69404 | Status: Closed |
DB2DART /LHWM DOES NOT LOWER XDA EXTENTS | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
db2dart /lhwm cannot lower the highwater mark, if the high water mark extents are being held by the xda extents. We can only use EXPORT/DROP/RECREATE/LOAD to move XDA, and XDA-EMP, for the table occupying the high water mark extent. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * V91 fp9 * **************************************************************** * PROBLEM DESCRIPTION: * * db2dart /lhwm cannot lower the highwater mark, if the high * * water * * mark extents are being held by the xda extents. * * * * * * * * We can only use EXPORT/DROP/RECREATE/LOAD to move XDA, and * * * * XDA-EMP, for the table occupying the high water mark extent. * **************************************************************** * RECOMMENDATION: * * Upgrade to V91fp10 * **************************************************************** | |
Local Fix: | |
use EXPORT/DROP/RECREATE/LOAD to move XDA, and XDA-EMP, for the table occupying the high water mark extent. | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Solution | |
Problem fixed in v91fp10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.06.2010 20.06.2011 20.06.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.10 |