home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList