home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC80356 Status: Geschlossen

UTILHEAP MEMORY LEAK WHEN AUTOMATIC STATISTICS COLLECTION PROCESSES A TABLE
WITH A STATISTICS PROFILE WITH INDEXES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
A leak to UTILHEAP occurs when automatic statistics collection 
processes a table with a statistics profile if the problem 
specifies the collection of index statistics. 
 
The leak might affect any database operations that require 
UTILHEAP. 
 
The leak can be observed with db2pd -memblocks option.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A leak to UTILHEAP occurs when automatic statistics          * 
* collection                                                   * 
* processes a table with a statistics profile if the problem   * 
* specifies the collection of index statistics.                * 
*                                                              * 
* The leak might affect any database operations that require   * 
* UTILHEAP.                                                    * 
*                                                              * 
* The leak can be observed with db2pd -memblocks option.       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 6.                        * 
****************************************************************
Local-Fix:
Unset the profile, which leads automatic statistics collection 
to use default statistics options.
verfügbare FixPacks:
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

Lösung
Problem first fixed in DB2 Version 9.7 Fixpack 6.
Workaround
see Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.12.2011
04.06.2012
04.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList