DB2 - Problembeschreibung
Problem IC67746 | Status: Geschlossen |
AFTER AN ABNORMAL SHUTDOWN OF HADR STANDBY, THE ACTIVATION OF THE DATABASE WILL START THE LOCAL CATCHUP WAY BACK IN TIME. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Due to code changes on 9.7 FP1 to address excessive I/O on standby when large buffer pool is used, standby is not flushing buffer pool pages on SOFTMAX. Some of the other symptoms customers will see are as follows: 1. Standby would retain logs longer than necessary since headextent ID/ minbufflsn is not moving up 2. Since minbufflsn is not moving faster, this may eventually cause log dir to fill up and shutdown standby. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users on a HADR env * **************************************************************** * PROBLEM DESCRIPTION: * * AFTER AN ABNORMAL SHUTDOWN OF HADR STANDBY, THE * * ACTIVATIONOFTHE DATABASE WILL START THE LOCAL CATCHUP WAY * * BACK IN TIME. * **************************************************************** * RECOMMENDATION: * * Upgrade to 9.7 FP2 * **************************************************************** | |
Local-Fix: | |
Monitor the standby and deactivate for every 50 or 100 log files it processes and reactivate the standby. Deactivate will flush the buffer pool pages on normal shutdown. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
AFTER AN ABNORMAL SHUTDOWN OF HADR STANDBY, THE ACTIVATION OF THE DATABASE WILL START THE LOCAL CATCHUP WAY BACK IN TIME. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC67757 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.04.2010 25.05.2010 09.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |