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

MEMORY LEAK IN MON_GET_LOCKS, MON_GET_APPL_LOCKWAIT TABLE FUNCTIONS
and MON_LOCKWAITS admin view

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
A memory leak of 6496 bytes per lock occurs as a result of 
calling the MON_GET_LOCKS or MON_GET_APPL_LOCKWAIT 
table functions or querying the MON_LOCKWAITS admin view. 
The leak is from the private memory heap. 
 
'db2mtrk -p -v' will show the leak 
 
Before calling MON_GET_LOCKS: 
 
Memory for agent 16 
 
   Other Memory is of size 20250624 bytes 
   Total: 20250624 bytes 
 
After calling MON_GET_LOCKS to return info on 1006 locks: 
 
Memory for agent 16 
 
   Other Memory is of size 26869760 bytes 
   Total: 26869760 bytes
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Any user calling MON_GET_LOCKS or MON_GET_APPL_LOCKWAIT or   * 
* querying MON_LOCKWAITS                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A memory leak of 6496 bytes per lock occurs as a result of   * 
* calling                                                      * 
*                                                              * 
* the MON_GET_LOCKS or MON_GET_APPL_LOCKWAIT table functions   * 
* or querying the MON_LOCKWAITS admin view.                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 FP2 or higher                                * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
The fix to properly free memory was included in v9.7 FP2. The 
memory leak will not occur anymore.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC67114 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.03.2010
23.04.2010
23.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList