DB2 - Problembeschreibung
Problem IC82414 | Status: Geschlossen |
"HEALTH MONITOR ALREADY IN USE" WAS RECORDED IN DB2DIAG.LOG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
If the Health Monitor crashes, while some db2agents are talking to health monitor with sqlerHmonSendRequest. There could be a problem in the restarting Health Monitor process. From db2diag.log 2012-03-09-01.32.04.586000+540 I1324199F407 LEVEL: Warning PID : 2068 TID : 2136 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-1050 APPID: *LOCAL.DB2.120308170020 AUTHID : DB2INST1 FUNCTION: DB2 UDB, routine_infrastructure, sqlerHmonSendRequest, probe:145 ESSAGE : Health Monitor Process crashed. 2012-03-09-01.32.04.586000+540 I1324608F386 LEVEL: Error PID : 2068 TID : 2136 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-1050 APPID: *LOCAL.DB2.120308170020 AUTHID : DB2INST1 FUNCTION: DB2 UDB, Automatic Table Maintenance, atmSendBuf, probe:900 ESSAGE : ZRC=0x00000047=71 ....... 2012-03-09-01.32.04.633000+540 I1325910F291 LEVEL: Severe PID : 2068 TID : 2404 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetHmonFmp, probe:30 ESSAGE : Health monitor already in use. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * If the Health Monitor crashes, while some db2agents are * * talking * * to health monitor with sqlerHmonSendRequest. * * There could be a problem in the restarting Health Monitor * * process. * * * * From db2diag.log * * * * 2012-03-09-01.32.04.586000+540 I1324199F407 LEVEL: * * Warning * * PID : 2068 TID : 2136 PROC : * * db2syscs.exe * * INSTANCE: DB2 NODE : 000 DB : * * SAMPLE * * APPHDL : 0-1050 APPID: * * *LOCAL.DB2.120308170020 * * AUTHID : DB2INST1 * * FUNCTION: DB2 UDB, routine_infrastructure, * * sqlerHmonSendRequest, * * probe:145 * * ESSAGE : Health Monitor Process crashed. * * * * 2012-03-09-01.32.04.586000+540 I1324608F386 LEVEL: * * Error * * PID : 2068 TID : 2136 PROC : * * db2syscs.exe * * INSTANCE: DB2 NODE : 000 DB : * * SAMPLE * * APPHDL : 0-1050 APPID: * * *LOCAL.DB2.120308170020 * * AUTHID : DB2INST1 * * FUNCTION: DB2 UDB, Automatic Table Maintenance, atmSendBuf, * * probe:900 * * ESSAGE : ZRC=0x00000047=71 * * * * ....... * * 2012-03-09-01.32.04.633000+540 I1325910F291 LEVEL: * * Severe * * PID : 2068 TID : 2404 PROC : * * db2syscs.exe * * INSTANCE: DB2 NODE : 000 * * FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetHmonFmp, * * probe:30 * * ESSAGE : Health monitor already in use. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.1 fixpack 12 * **************************************************************** | |
Local-Fix: | |
A DB2 Instance restart , will restart the Health Monitor | |
Lösung | |
Problem is fixed in DB2 version 9.1 fix pack 12 Health Monitor restarts without a problem after the fix. | |
Workaround | |
Restart the DB2 Instance | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.04.2012 02.08.2012 02.08.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP12 | |
Problem behoben lt. FixList in der Version | |
9.1.0.12 |