DB2 - Problem description
Problem IT00925 | Status: Closed |
INSPECT UTILITY REPORTS FALSE ERROR ON MDC TABLES | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
When you run INSPECT utility to check MDC (Multi Dimensional Clustering) tables in your database you might get false error reports. The error in the INSPECT report will look like following for example: --- Error: Found error type (scan relative page 8148 EMP 258995 with entries 12 after 1st non-full EMP at scan relative page 150) drtbps.C dartScanExtentMapObject 1063 --- This error says that INSPECT found multiple EMPs (Extent Map Pages) that do not contain the maximum number of entries. These holes are expected for MDC tables and therefore no error. This APAR will ensure INSPECT utility with DB2 v9.7 does not report this as an error. INSPECT utility with DB2 v10.1 and newer does not hit this issue. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 FixPack 10. * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 version 9.7 FixPack 10. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.04.2014 18.11.2014 18.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |