DB2 - Problembeschreibung
Problem IC75872 | 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 / 910 - 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 * **************************************************************** * 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.1 FP11 * **************************************************************** | |
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.1 Fix Pack 11 for Linux, UNIX and Windows | |
Lösung | |
After applied this fix the problem on memory leak of monitor heap won't occurred again when detaching the instance attachment. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC75915 IC75916 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.04.2011 10.12.2011 10.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP11 | |
Problem behoben lt. FixList in der Version | |
9.1.0.11 |