DB2 - Problembeschreibung
Problem IT03920 | Status: Geschlossen |
GRACEFUL TAKEOVER IS SLOW DUE TO UNDO WAS FIGHTING LOGGR PRE-ALLOCATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Graceful takeover was slow, in the minutes. This was because takeover was being issued shortly after the primary activated and we had not internally pre-allocated log active. So when the takeover request came in and on the primary we had quite a few transaction to rollback, undo was fighting db2loggr pre-allocation. We spent too much time in pre-allocation not enough time servicing read log requests for undo. This is a regression due to our recent changes to allocate 2 files on startup and the remaining files after the fact. The solution is a cheap fix. While takeover is in progress to avoid doing any file pre-allocation. This way db2loggr is focused on rollback not taking up cycles allocating files. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * HADR takeover slow * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v101fp5 or v105fp5. * **************************************************************** | |
Local-Fix: | |
If possible, before issuing the graceful TAKEOVER, wait until all logs in the active log path are pre-allocated. | |
Lösung | |
the fix will be delivered to v101 and v105. the slow takeover problem will be resolved. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.08.2014 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |