DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the following conditions exist: 
- automatic statistics collection is enabled 
- a table has a statistics profile which does not include 
distribution statistics for any column in the table 
- automatic statistics collection collects statistics for the 
table 
a leak to utility heap might occur depending on how the 
statistics collection was performed.  The factors that can 
influence whether the leak will occur are not deterministic. 
 
The -memblocks option of db2pd can be used to look for leaks. 
The leaked memory is released when the database is deactivated.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 7.                              * 
****************************************************************

Exclude the affected tables from automatic statistics 
collection, and manually collect statistics for these tables.

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
 

This problem is first fixed in DB2 Version 9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

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

02.08.2012
23.10.2012
23.10.2012

9.7.FP7