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

MONITOR HEAP LEAKING IN SIZE 16 AND 24 BYTES MAY OCCUR IF THERE ARE MANY
TASKS RUN LIKE RESET MONITOR AND INSTANCE DETACH.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
If there are many tasks like "db2 reset monitor all" and "db2 
detach" run in the background, from the the db2pd -memblock 
output, it could be perceived that db2 is leaking 16 and 24 
bytes monitor memory at a stretch, like below: 
 
Address            PoolID     PoolName     BlockAge 
Size(Bytes)  I LOC   File 
0x0780000003694AC8 11         monh         7195       24 
  1 146   3254716357 
0x0780000003694B08 11         monh         43116      16 
  1 146   3254716357 
0x0780000003694B48 11         monh         43117      24 
  1 146   3254716357 
0x078000000369D8C8 11         monh         63753      16 
  1 146   3254716357 
0x078000000369D908 11         monh         63754      24 
  1 146   3254716357 
0x078000000369DA28 11         monh         27486      16 
  1 146   3254716357 
0x078000000369DA68 11         monh         27487      24 
  1 146   3254716357 
0x078000000369DDA8 11         monh         19330      16 
  1 146   3254716357 
0x078000000369DE68 11         monh         30457      16 
  1 146   3254716357 
0x078000000369DF68 11         monh         55378      16 
  1 146   3254716357 
... 
 
Under such condition, the monitor memory heap will NOT be 
released all the while and the error DIA8300C will be come up 
with in the db2diag.log at the end as below: 
 
2011-04-11-13.52.10.204659+480 I1287415A500       LEVEL: Severe 
 
PID     : 2150452              TID  : 1           PROC : 
db2agent 
(instance) 0 
 
INSTANCE: db2inst1             NODE : 000 
 
APPHDL  : 0-298                APPID: 
*LOCAL.db2inst1.2007070720080708 
AUTHID  : hujinpei 
 
FUNCTION: DB2 UDB, database monitor, sqm_object::new, probe:100 
 
RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH 
 
          "No memory available in 'Database Monitor Heap'" 
 
          DIA8300C A memory heap error has occurred.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If there are many tasks like "db2 reset monitor all" and     * 
* "db2 detach" run in the background, from the the db2pd       * 
* -memblock output, it could be perceived that db2 is leaking  * 
* 16 and 24 bytes monitor memory at a stretch, like below:     * 
*                                                              * 
* Address            PoolID    PoolName    BlockAge            * 
* Size(Bytes)  I LOC  File                                     * 
* 0x0780000003694AC8 11        monh        7195      24        * 
*   1 146  3254716357                                          * 
* 0x0780000003694B08 11        monh        43116      16       * 
*   1 146  3254716357                                          * 
* 0x0780000003694B48 11        monh        43117      24       * 
*   1 146  3254716357                                          * 
* 0x078000000369D8C8 11        monh        63753      16       * 
*   1 146  3254716357                                          * 
* 0x078000000369D908 11        monh        63754      24       * 
*   1 146  3254716357                                          * 
* 0x078000000369DA28 11        monh        27486      16       * 
*   1 146  3254716357                                          * 
* 0x078000000369DA68 11        monh        27487      24       * 
*   1 146  3254716357                                          * 
* 0x078000000369DDA8 11        monh        19330      16       * 
*   1 146  3254716357                                          * 
* 0x078000000369DE68 11        monh        30457      16       * 
*   1 146  3254716357                                          * 
* 0x078000000369DF68 11        monh        55378      16       * 
*   1 146  3254716357                                          * 
* ...                                                          * 
*                                                              * 
* Under such condition, the monitor memory heap will NOT be    * 
* released all the while and the error DIA8300C will be come   * 
* up with in the db2diag.log at the end as below:              * 
*                                                              * 
* 2011-04-11-13.52.10.204659+480 I1287415A500      LEVEL:      * 
* Severe                                                       * 
*                                                              * 
* PID    : 2150452              TID  : 1          PROC :       * 
* db2agent                                                     * 
* (instance) 0                                                 * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000                     * 
*                                                              * 
* APPHDL  : 0-298                APPID:                        * 
* *LOCAL.db2inst1.2007070720080708                             * 
* AUTHID  : hujinpei                                           * 
*                                                              * 
* FUNCTION: DB2 UDB, database monitor, sqm_object::new,        * 
* probe:100                                                    * 
*                                                              * 
* RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH         * 
*                                                              * 
*           "No memory available in 'Database Monitor Heap'"   * 
*                                                              * 
*           DIA8300C A memory heap error has occurred.         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.5 FP9                                          * 
****************************************************************
Local-Fix:
The memory lack only happen when detaching the instance 
attachment. Keep using the same instance attachment to do the 
"reset monitor" and snapshot could avoid the memory leak.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
The problem has been included in v9.5 FP9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.04.2011
13.03.2012
13.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList