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

HEALTH MONITOR FAILS TO DIFFERENTIATE BETWEEN HADR PRIMARY AND SECONADRY
AFTER HADR TAKEOVER.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Health monitor, when configured with HADR, throws errors after 
HADR takeover. We need to fix the gap between HADR and Hmon, 
hmon is not working in HADR environment. Health monitor is mot 
able to pick up the new primary after HADR takeover and it 
continues to assume the old primary as a primary (which is 
standby actually). db2acd should indicate that DB is inactive to 
all plugins hosted within acd. 
 
Here are few sample error messages in db2diag.log after take 
over : 
 
---------------------------- 
2010-12-20-18.28.00.812000+060 I6243504F789       LEVEL: Warning 
PID     : 44276                TID  : 43516       PROC : 
db2fmp64.exe 
INSTANCE: DB2                  NODE : 000 
EDUID   : 43516 
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:70 
CALLED  : DB2 UDB, Health Monitor, hmonBkpGetHmonSQLConnection 
RETCODE : ZRC=0xFFFFFFFF=-1 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1060   sqlerrml: 7 
 sqlerrmc: DB2HMON 
 sqlerrp : SQLELOST 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 08004 
 
2010-12-20-18.28.00.812000+060 I6244295F346       LEVEL: Event 
PID     : 44276                TID  : 43516       PROC : 
db2fmp64.exe 
INSTANCE: DB2                  NODE : 000 
EDUID   : 43516 
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:270 
STOP    : Automatic Backup: evaluation has finished with errors 
on database SAMPLE 
 
------------------------------ 
 
Hence, the gap between Health monitor and HADR needs to be 
bridged.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users on DB2 V9.7 FixPack 4 or below                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Health monitor, when configured with HADR, throws errors     * 
* after                                                        * 
* HADR takeover. We need to fix the gap between HADR and Hmon, * 
*                                                              * 
* hmon is not working in HADR environment. Health monitor is   * 
* mot                                                          * 
* able to pick up the new primary after HADR takeover and it   * 
*                                                              * 
* continues to assume the old primary as a primary (which is   * 
*                                                              * 
* standby actually). db2acd should indicate that DB is         * 
* inactive to                                                  * 
* all plugins hosted within acd.                               * 
*                                                              * 
*                                                              * 
*                                                              * 
* Here are few sample error messages in db2diag.log after take * 
*                                                              * 
* over :                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* ----------------------------                                 * 
*                                                              * 
* 2010-12-20-18.28.00.812000+060 I6243504F789      LEVEL:      * 
* Warning                                                      * 
* PID    : 44276                TID  : 43516      PROC :       * 
*                                                              * 
* db2fmp64.exe                                                 * 
*                                                              * 
* INSTANCE: DB2                  NODE : 000                    * 
*                                                              * 
* EDUID  : 43516                                               * 
*                                                              * 
* FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup,        * 
* probe:70                                                     * 
* CALLED  : DB2 UDB, Health Monitor,                           * 
* hmonBkpGetHmonSQLConnection                                  * 
* RETCODE : ZRC=0xFFFFFFFF=-1                                  * 
*                                                              * 
* DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes                * 
*                                                              * 
* sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -1060  sqlerrml: 7 * 
* sqlerrmc: DB2HMON                                            * 
*                                                              * 
* sqlerrp : SQLELOST                                           * 
*                                                              * 
* sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)        * 
*                                                              * 
* 0x00000000                                                   * 
*                                                              * 
*           (4) 0x00000000      (5) 0x00000000      (6)        * 
*                                                              * 
* 0x00000000                                                   * 
*                                                              * 
* sqlwarn : (1)      (2)      (3)      (4)        (5)      (6) * 
*                                                              * 
*                                                              * 
*                                                              * 
*           (7)      (8)      (9)      (10)        (11)        * 
*                                                              * 
* sqlstate: 08004                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-12-20-18.28.00.812000+060 I6244295F346      LEVEL:      * 
* Event                                                        * 
* PID    : 44276                TID  : 43516      PROC :       * 
*                                                              * 
* db2fmp64.exe                                                 * 
*                                                              * 
* INSTANCE: DB2                  NODE : 000                    * 
*                                                              * 
* EDUID  : 43516                                               * 
*                                                              * 
* FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup,        * 
* probe:270                                                    * 
* STOP    : Automatic Backup: evaluation has finished with     * 
* errors                                                       * 
* on database SAMPLE                                           * 
*                                                              * 
*                                                              * 
*                                                              * 
* ------------------------------                               * 
*                                                              * 
*                                                              * 
*                                                              * 
* Hence, the gap between Health monitor and HADR needs to be   * 
*                                                              * 
* bridged.                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FixPack 5 or higher.                     * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem first fixed in DB2 V9.7 FixPack 5.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC90436 IC96298 IC96349 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.04.2011
16.12.2013
16.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList
9.7.0.9 FixList
9.7.0.9 FixList