DB2 - Problembeschreibung
Problem IC83130 | Status: Geschlossen |
INDEX CORRUPTION IN PURESCALE MODE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problembeschreibung: | |
In pureScale, different members have their own transaction log records with their own log sequence numbers (LSNs). Periodically we must synchronize the log sequence numbers across all of the members in the pureScale cluster. There is a case where we failed to do a log synchronize of the log sequence numbers during create index and that can lead to a corruption of the index when dropping and then recreating an index that is not the last index on the table. For the corruption to occur, there must be updates to the table made from another member immediately before the drop index occurs and that member must crash and require member crash recovery. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * pureScale environment * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.8.0.5. * **************************************************************** | |
Local-Fix: | |
Run REORG INDEXES ALL with the ALL NO ACCESS option to recreate the affect index object. | |
Lösung | |
The problem is first fixed in DB2 version 9.8.0.5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.05.2012 14.06.2012 14.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.0.5 | |
Problem behoben lt. FixList in der Version | |
9.8.0.5 |