|
Problem IC74395
|
Status: Geschlossen |
THROUGHPUT DECREASE AND CPU USAGE INCREASE WHEN STATEMENT MONITOR SWITCH ON |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When a significant number of applications are executing a small
number of statements, turning on statement monitoring may result
in CPU spiking and reduced throughput as latch contention occurs
in the dynamic SQL entries in the package cache.
Stack dumps will show the sqlra_anchor_stmt as being the
contentious latch. Various calling stacks are possible and are
not included here. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* statement monitor switch on *
****************************************************************
* PROBLEM DESCRIPTION: *
* performance decrease with statement monitor on. CPU kernel *
* increase *
****************************************************************
* RECOMMENDATION: *
* move to DB2 for LUW version v9.5 fxpack 8 *
**************************************************************** |
| Local-Fix: |
turn off statement montoring. |
| verfügbare FixPacks: |
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 |
Fixed in DB2 for LUW version v9.5 fxpack 8 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.02.2011
05.07.2011
05.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
