DB2 - Problem description
Problem IC95272 | Status: Closed |
DB2DART /RHWM COMMAND FAILS AND REPORTS ERRORS AS IT IS TRYING TO ACCESS NONEXISTING PAGE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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.5 GA through to Version 10.5 Fix * * Pack 2. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to 10.5.0.3 * **************************************************************** | |
Local Fix: | |
There are two recommended ways to reduce HWM instead of using db2dart /RHWM If tablespace is reclaimable storage enabled use "ALTER TABLESPACE LOWER HIGH WATER MARK" statement. If tablespace is not reclaimable storage enabled use "ALTER TABLESPACE REDUCE" statement. | |
available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem Fixed In 10.5.0.3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.08.2013 28.08.2014 28.08.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.3 | |
10.5.0.3 |