DB2 FOR LUW / DB2FORLUW / 950 - DB2

DB2 starts background tasks (threads) to do database maintenance 
work such as asynchronous index cleanup. 
There is no effective limit on the number of background tasks 
that can be created. 
As an example, if a lot of table partitions are detached from a 
range partitioned table then too many background tasks are 
started 
which can consume all available machine resources. The instance 
may crash or become unresponsive due to 
resource exhaustion.

**************************************************************** 
* USERS AFFECTED:                                              * 
* 950                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 starts background tasks (threads) to do                  * 
* databasemaintenancework such as asynchronous index           * 
* cleanup.There is no effective limit on the number of         * 
* backgroundtasksthat can be created.As an example, if a lot   * 
* of table partitions are detachedfrom arange partitioned      * 
* table then too many background tasks arestartedwhich can     * 
* consume all available machine resources. Theinstancemay      * 
* crash or become unresponsive due toresource exhaustion.      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Try to avoid detaching a lot of table partitions at once.    * 
****************************************************************

Try to avoid detaching a lot of table partitions at once.

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

First fixed in DB2 Version 9.5 Fix Pack 7

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC69285 IC71730 
Nachfolger : 

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

13.04.2010
15.11.2010
14.07.2011

9.5.FP7