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

LARGE CPU OVERHEAD WHEN THE UOW EVENT MONITOR IS ACTIVE AND COLLECTING
DATA

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When an UOW, Activities, Locking or Package Cache event monitor 
is active and collecting data, workloads can experience a large 
CPU overhead by the fast writer threads which are processing and 
committing the event monitor records.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Anybody using an UOW, Activities, Locking or Package Cache   * 
* event monitor.                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When an UOW, Activities (SQL Table only, not File or Pipe),  * 
* Locking or Package Cache event monitor is active and         * 
* collecting data, the fast writer threads can consume a large * 
* amount of CPU time.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 Fix Pack 2 or higher.                        * 
****************************************************************
Local-Fix:
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 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
In V9.7 Fix Pack 2 the fast writer threads (db2fw0, db2fw1, 
db2fw2, db2fw3) will consume less CPU time.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC66555 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.02.2010
14.05.2010
14.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList