DB2 - Problembeschreibung
| Problem IC72908 | Status: Geschlossen |
LOGGER SCALABILITY (ROLLFORWARD AND CRASH RECOVERY) MAY CAUSE PROBLEMS ON DPF MLN ENVIRONMENTS | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problembeschreibung: | |
Usually DB2 will create the same number of redo workers as the number of cpu's on the machine. For example, if your machine has 4 CPUs, DB2 will create 4 redo workers for rollforward or crash recovery. This can cause a problem in a DPF MLN environment. For example, if you have 3 nodes and do a rollforward on all 3 nodes, you may end up with 12 redo workers which could cause performance degradation. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DPF databases * **************************************************************** * PROBLEM DESCRIPTION: * * Usually DB2 will create the same number of redo workers as * * the * * number of cpu's on the machine. For example, if your * * machine * * has 4 CPUs, DB2 will create 4 redo workers for rollforward * * or * * crash recovery. This can cause a problem in a DPF MLN * * * * environment. For example, if you have 3 nodes and do a * * * * rollforward on all 3 nodes, you may end up with 12 redo * * workers * * which could cause performance degradation. * **************************************************************** * RECOMMENDATION: * * Apply Version 9.5 Fixpack 7 * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
| Lösung | |
Apply Version 9.5 Fixpack 7 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.11.2010 31.01.2011 31.01.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
| Problem behoben lt. FixList in der Version | |
| 9.1.0.7 |
|
| 9.5.0.7 |
|