DB2 - Problembeschreibung
Problem IT05640 | Status: Geschlossen |
DURING THE UPGRADE OF THE DATABASE THE FOLLOWING ERROR MAYBE SEEN SQL0206N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
This could be caused by the database having inconsistencies in the statistics between the tables and its indexes. This inconsistency then causes the upgrade of the database to fail, and stops the upgrade process. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DURING THE UPGRADE OF THE DATABASE THE FOLLOWING ERROR MAYBE * * SEEN SQL0206N * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First fixed in fix pack 5 of v10.1 * **************************************************************** | |
Local-Fix: | |
It is recommended to restore the database on the original DB2 Level, then run a fresh runstats on both the tables and indexes (using the AND INDEXES ALL clause). It is recommended to do this on all tables within the database. | |
Lösung | |
First fixed in fix pack 5 of v10.1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.11.2014 15.07.2015 15.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |