|
Problem IC69285
|
Status: Closed |
TOO MANY BACKGROUND TASKS ARE BEING STARTED WHICH CAN CONSUME ALL AVAILABLE MACHINE RESOURCES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
Try to avoid detaching a lot of table partitions at once. |
| available fix packs: |
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
|
| Solution |
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 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.06.2010
02.05.2011
22.10.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
