|
Problem IC65555
|
Status: Geschlossen |
HIGH CPU USAGE IN A SCENARIO WITH TABLE QUEUE SPILLING |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The mechanism that is used to flow rows between agents in a DPF
environment is called tablequeues. There exists a flow control
mechanism to regulate the flow of rows called a tablequeue spill
that will decide to defer the sending of data by spilling it
into a temp table.
In a configuration with many database partitions, for example,
over 50 partitions or so, then due to this defect there may be
some logic that does unnecessary work thereby driving up the cpu
usage.
If stacks are collected for an agent that is trying to resend
spilled buffers, the function "StartSpillResends" might be seen
in this scenario as being a large consumer of cpu cycles.
This fix will rework the logic in a way that will remove the
unneeded work and help alleviate the cpu usage. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DPF with large node config (100+) *
****************************************************************
* PROBLEM DESCRIPTION: *
* High cpu usage during tablequeue spilling. *
****************************************************************
* RECOMMENDATION: *
* Install fixpack 6 *
**************************************************************** |
| 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 |
fix is contained in v95FP6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.01.2010
12.07.2010
12.07.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
