DB2 - Problembeschreibung
Problem IC96452 | Status: Geschlossen |
HADR STANDBY CAN BE SLOW DUE TO INDEX MAINTENANCE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
HADR standby can slow down due to index maintenance. The reason is due to the fact that lot of the index page split, page merge and other records generated in the log are mostly tablespace blocking records which cause them to run serially on the same tablespace. Some log records related to create/reorg index have also had their blocking level improved to allow for faster replay on the standby. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply the workaround i..e spread the indexes in multiple * * tablespaces and upgrade to DB v9.7 Fixpack 9 * **************************************************************** | |
Local-Fix: | |
Spread the indexes to different tablespaces. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 v9.7 Fixpack 9. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.09.2013 16.12.2013 16.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |