DB2 - Problembeschreibung
Problem IC67423 | Status: Geschlossen |
DB2DART FAILS TO IDENTIFY INITIALIZED BUT UNUSED EXTENT MAP PAGES THAT ARE CORRUPT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In a DMS tablespace, when a table is created, an entire extent of Extent Map Pages (EMP) are initialized. Initially, only the first page of this EMP extent is used. If an unused EMP page becomes corrupted (due to hardware failure), then db2dart is not able to idenitfy this corruption. If this corrupt page is ever accessed, either as a result of growing the table, reorganizing the table, or dropping the table, then the database will crash with a bad page error. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * In a DMS tablespace, when a table is created, an entire * * extent * * of Extent Map Pages (EMP) are initialized. Initially, only * * the * * first page of this EMP extent is used. If an unused EMP page * * * * becomes corrupted (due to hardware failure), then db2dart is * * not * * able to idenitfy this corruption. * * * * If this corrupt page is ever accessed, either as a result of * * * * growing the table, reorganizing the table, or dropping the * * * * table, then the database will crash with a bad page error. * **************************************************************** * RECOMMENDATION: * * Upgrade DB2 to 9.7 Fix Pack 3 * **************************************************************** | |
Local-Fix: | |
Use 'db2 inspect' command instead of db2dart | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.03.2010 23.09.2010 23.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |