|
Problem IC65712
|
Status: Closed |
System controller EDU (DB2SYSC) held up due to contention for th e FCM dynamic update latch causes apparent performance slowdown. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Multiple logical nodes on the same machine share the same FCM
resource pools. The system controller EDU (db2sysc) on each
logical node wakes up periodically to determine if FCM
resource tuning is necessary. The system controller EDUs
contend for the FCM dynamic update latch in order to perform
the tuning. The remaining system controller EDUs and agent EDUs
can end up waiting for the latch until tuning completes and the
latch
is released. This can lead to performance slowdowns. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Large MLN setup on all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* Multiple logical nodes on the same machine share the same *
* FCM *
* resource pools. The system controller EDU (db2sysc) on each *
* *
* logical node wakes up periodically to determine if FCM *
* *
* resource tuning is necessary. The system controller EDUs *
* *
* contend for the FCM dynamic update latch in order to perform *
* *
* the tuning. The remaining system controller EDUs and agent *
* EDUs *
* can end up waiting for the latch until tuning completes and *
* the *
* latch is released. This can lead to performance slowdowns. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 fixpack 2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
For large MLN environments customers should see less performance
degradation due to this issue. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2010
16.08.2010
16.08.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
