DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 database instances on Windows may, over time, accumulate a 
large number of Windows handles associated with named events. 
This occurs when running a large number of LOAD FROM CURSOR 
operations.  In some cases this accumulation can contribute to 
degraded performance. 
 
Note that this problem does not occur when loading from a 
"remote fetch" cursor (i.e. where the cursor is declared using 
the DATABASE keyword), and/or when the DB2 system is a 
partitioned database environment (DPF). 
 
The number of Windows handles used by the DB2 engine process may 
be observed using the Windows Task Manager. 
 
This problem affects DB2 on Windows systems only.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

Restart the DB2 server if the number of handles observed is 
large (more than 100,000) and performance is degraded.

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
 

First fixed in DB2 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

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

09.10.2013
16.12.2013
16.12.2013

9.7.FP9