DB2 - Problembeschreibung
Problem IT05031 | Status: Geschlossen |
RESTART DATABASE TAKES LONGER THAN NECESSARY ON SYSTEMS WITH A LARGE NUMBER OF TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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: * * Systems with a large number of tables may be impacted * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix pack 7 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem first fixed in DB2 Version 10.5 Fix Pack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.10.2014 16.02.2016 16.02.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |