home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  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 FixList