DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 fp5 or higher. Set                        * 
* DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:limit if a limit  * 
* on background                                                * 
* system applications is desired.                              * 
****************************************************************

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

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 8 for Linux, UNIX, and Windows
 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
 

The fix for this APAR included in v9.7 FP4 incorrectly counted 
fast writer EDUs towards the limit on background system 
applications. 
This is corrected in APAR IC76118 which restored the default 
behaviour present in fp3 or earlier. To implement the fix for 
this APAR, 
set the following registry variable: 
DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:limit

keiner bekannt / siehe Local-Fix

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

16.06.2010
02.05.2011
22.10.2011

9.7.FP4,
9.7.FP5