|
Problem IC65555
|
Status: Closed |
HIGH CPU USAGE IN A SCENARIO WITH TABLE QUEUE SPILLING |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF with large node config (100+) *
****************************************************************
* PROBLEM DESCRIPTION: *
* High cpu usage during tablequeue spilling. *
****************************************************************
* RECOMMENDATION: *
* Install fixpack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
fix is contained in v95FP6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.01.2010
12.07.2010
12.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
