DB2 FOR LUW / DB2FORLUW / 970 - DB2

When having a large number of tablespaces (> 500), the execution 
of the table function HEALTH_CONT_HI() may loop and cause 
db2fmp to consume high cpu (close to 100%). 
. 
Please note that health monitor is currently limited to monitor 
up to 500 tablespaces as documented in the following technote: 
. 
http://www-01.ibm.com/support/docview.wss?&uid=swg21398397 
. 
The fix does not lift the limitation. Instead, it will 
ensure that the table function runs successfully without 
looping, but will truncate the resultset to 500 tablespaces, as 
with other tablespace related health monitor data.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Problem Description: Invocation of HEALTH_CONT_HI()          * 
* TABLEFUNCTION hangs and causes DB2FMP HIGH CPU USAGE         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* The fix does not lift the health monitor restriction         * 
* tomonitor 500 tablespaces max. So, the recommendation is     * 
* toavoid using health monitor for tablespace usage            * 
* monitoring.To limit the impact health_cont_hi() on databases * 
* havingmore than 500 tablespaces, upgrade to product V9.7 Fix * 
* Pack2.                                                       * 
****************************************************************

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 V9.7 Fix Pack 2

keiner bekannt / siehe Local-Fix

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

08.09.2009
31.05.2010
31.05.2010

9.7.,
9.7.FP2