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 IC76773 Status: Geschlossen

THE INSPECT TOOL CAN LEAK MEMORY WHEN INCORRECTLY INSERTING A COMPRESSION
DICTIONARY

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The DB2 INSPECT ROWCOMPESTIMATE option estimates the 
effectiveness of row compression for a table. It can leak memory 
when the compression dictionary was built successfully but 
attempting to insert it into table didn't succeed or complete. 
For such case, the dictionary should be free'ed from the memory. 
 The most common situation for this is when INSPECT 
ROWCOMPESTIMATE runs against a table that does not support data 
row compression.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of the INSPECT utility                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The DB2 INSPECT ROWCOMPESTIMATE option estimates the         * 
* effectiveness of row compression for a table. It can leak    * 
* memory                                                       * 
* when the compression dictionary was built successfully but   * 
* attempting to insert it into table didn't succeed or         * 
* complete.                                                    * 
* For such case, the dictionary should be free'ed from the     * 
* memory.                                                      * 
* The most common situation for this is when INSPECT           * 
* ROWCOMPESTIMATE runs against a table that does not support   * 
* data                                                         * 
* row compression.                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP5 or newer                             * 
****************************************************************
Local-Fix:
Restart the database to free the leaked memory in DBHEAP
verfügbare FixPacks:
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

Lösung
Upgrade to DB2 v9.7 FP5 or newer
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.06.2011
20.12.2011
20.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList