DB2 - Problem description
Problem IC91705 | Status: Closed |
DB2DART /RHWM COMMAND FAILS AND REPORTS ERRORS AS IT IS TRYING TO ACCESS NONEXISTING PAGE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
db2dart /rhwm might fail with following error: --- High water mark processing - phase start. Reduce high water mark processing - phase start. Error: Attempting to access a page (175214607) which does not exist. The total number of pages in this tablespace is 2732032. Error: Unable to read pool page 175214607, from pool 5, due to rc 0x0 Error: parent pool 5, object ID 65534, object type Unknown. Error: extent map anchor page of object is 0. Error: failed to find the index of the last used smp extent Reduce high water mark processing - phase end. Error: This phase encountered an error and did not complete. High water mark processing - phase end. --- | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems on all Linux, Unix and Windows platforms at * * service levels Version 10.1 GA through to Version 10.1 Fix * * Pack 2. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3. * **************************************************************** | |
Local Fix: | |
There are two recommended ways to reduce HWM instead of using db2dart /RHWM. Use "ALTER TABLESPACE REDUCE" command or "ALTER TABLESPACE LOWER HIGH WATER MARK" command. | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
The complete fix for this problem first appears in DB2 Version 10.1 Fix Pack 3 and all the subsequent Fix Packs. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC95272 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.04.2013 03.11.2013 03.11.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |