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 IC64403 Status: Geschlossen

System controller EDU (DB2SYSC) held up due to contention for th e FCM
dynamic update latch causes apparent performance slowdown.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL ESE + DPF users                                          * 
**************************************************************** 
* 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 v95 fixpack 6 or higher.                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
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

Lösung
FCM self-tuning should use a best-effort approach --if a 
db2sysc cannot get the latch to perform the operation, it will 
 
retry in 
the next tuning interval.  The system controller EDUs should not 
be held up for 
a long period of time. 
 
This issue is fixed in v95 fixpack 6. Customer should not see 
performance slowdown due to db2sysc waiting behind the tuning 
latch.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC65712 IC80198 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.11.2009
05.03.2010
05.03.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version