|
Problem IC72908
|
Status: Closed |
LOGGER SCALABILITY (ROLLFORWARD AND CRASH RECOVERY) MAY CAUSE PROBLEMS ON DPF MLN ENVIRONMENTS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Apply Version 9.5 Fixpack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.11.2010
31.01.2011
31.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
