|
Problem IC67852
|
Status: Closed |
TOO MANY BACKGROUND TASKS ARE BEING STARTED WHICH CAN CONSUME ALL AVAILABLE MACHINE RESOURCES |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: *
* 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. *
**************************************************************** |
| Local Fix: |
Try to avoid detaching a lot of table partitions at once. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.5 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69285 IC71730
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.04.2010
15.11.2010
14.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
