DB2 FOR LUW / DB2FORLUW / 970 - DB2

The checkinterval for the rowsread and cputime thresholds does 
not work properly on 32-bit platforms. The value specified is 
effectively ignored, and these thresholds are checked every 
second (or more frequently). This can lead to severe 
performance problems.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use the CPUTIME, CPUTIMEINSC, ROWSREAD or          * 
* ROWSREADINSC WLM thresholds on 32-bit platforms              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* For the CPUTIME, CPUTIMEINSC, ROWSREAD and ROWSREADINSC WLM  * 
* thresholds, the check interval controls how often these      * 
* thresholds are evaluated while a query is running. The check * 
* interval is user configurable when the thresholds are        * 
* created, the default is 60 seconds. A low check interval has * 
* the trade off that the thresholds will detect violations     * 
* more quickly, at the expense of evaluating more frequently   * 
* (which will consume resources).                              * 
* On 32-bit platforms, the check interval is ignored and       * 
* checking occurs at a 1 second (or lower) interval. This may  * 
* result in performance problems if the threshold is applied   * 
* to a large number of statements executing concurrently.      * 
* There is no work around.                                     * 
* A user encountering this problem would see higher than       * 
* expected CPU consumption on statements on which the          * 
* thresholds were applied. Problem would only be encountered   * 
* on 32-bit platforms, and only for the 4 thresholds listed.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack 1                    * 
****************************************************************

No local fix other than avoiding use of the cputime and 
rowsreadthresholds on 32-bit platforms.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 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 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 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
 

The problem is fixed in DB2 LUW Version 9.7, Fix Pack 1. There 
is no workaround. The thresholds will still work, but will not 
respect the checking interval and will consume more resources 
than expected which may impact other work running on the system.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.10.2009
03.11.2009
03.11.2009

9.7.FP1