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 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 FixList