|
Problem IC79285
|
Status: Geschlossen |
UNDER HEAVY OLTP WORKLOADS ON AIX, SYSTEM-CPU USAGE MAY SPIKE CAUSING AN IMPACT TO DB2 PERFORMANCE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 uses a latching implementation which uses AIX thread_lock()
/ thread_unlock() APIs.
Under very heavy workloads, when hundreds or more threads are
waiting on and waking on the same latch/lock, it's possible for
a spike in system-cpu usage to occur, which can significantly
impact DB2 performance. Spikes can last for short (minutes) or
long (tens of minutes) duration.
To enable this APAR fix on db2, the following db2 registry needs
to be set:
db2set DB2_ENABLE_THREAD_UNLOCK_EXTENDED=YES
db2stop force
db2start
AIX Level that includes the prerequisite APAR fix
6.1 TL06 SP7 (IV10411)
6.1 TL07 SP2 (IV10010)
6.1 TL08 (IV13362)
7.1 GA SP5 (IV14638)
7.1 TL01 SP2 (IV09962) |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97 fixpak 6. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.10.2011
06.06.2012
05.11.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
