DB2 - Problembeschreibung
Problem IT05021 | Status: Geschlossen |
RESTART DATABASE TAKES LONGER THAN NECESSARY ON SYSTEMS WITH A LARGE NUMBER OF TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When INDEXREC is set to RESTART, the RESTART DATABASE command will rebuild any indexes marked as needing to be rebuilt. All table objects in the database must be checked to determine the state of their indexes. This process may take longer than necessary as all metadata is loaded, requiring reads from disk. Systems making use of table partitioning are more heavily impacted as each table partition is a separate object. Compressed tables are also more expensive due to the cost of loading the compression dictionary (and each table partition has its own dictionary). This APAR fix substantially reduces the amount of metadata which must be loaded when checking the state of a table's indexes. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Systems are affected * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 11 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem first fixed in DB2 Version 9.7 Fix Pack 11 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.10.2014 20.10.2015 20.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |