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

HADR PRIMARY REINTEGRATION SHOULD NOT HAPPEN WHEN TSA IS IN MANUAL MODE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
In a HADR scenario normally when the primary fails, the standby 
will takeover by force. 
Then later on when primary comes back up, it should reintegrate 
to become new Standby. 
 
However, when TSA is in Manual mode, this means automation is 
disabled, and no action should be taken. But this is not the 
case right now. We perform reintegration at the monitor script, 
so even if TSA Manual mode is enabled, reintegration will still 
occur. 
 
This is not the desired effect because it is not honouring the 
TSA Manual mode. 
 
The expectation is that no automation (including reintegration) 
should occur when TSA is in Manual mode.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Integrated HA solution users where TSA is used as the        * 
* cluster manager to automate HADR failover.                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In a HADR scenario normally when the primary fails, the      * 
* standby will takeover by force.                              * 
* Then later on when primary comes back up, it should          * 
* reintegrate to become new Standby.                           * 
*                                                              * 
* However, when TSA is in Manual mode, this means automation   * 
* is disabled, and no action should be taken. But this is not  * 
* the case right now. We perform reintegration at the monitor  * 
* script, so even if TSA Manual mode is enabled, reintegration * 
* will still occur.                                            * 
*                                                              * 
* This is not the desired effect because it is not honouring   * 
* the TSA Manual mode.                                         * 
*                                                              * 
* The expectation is that no automation (including             * 
* reintegration) should occur when TSA is in Manual mode.      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 V9.5 FixPak 7                                      * 
****************************************************************
Local-Fix:
Change the hadr_monitor script such that it checks whether TSA 
is in Manual mode. 
If in manual mode, then skip the db2gcf call and continue with 
the db2pd / snapshot checks. 
 
e.g. 
+   manual=$(lssamctrl | grep -c "Manual") 
+   if [[ $manual == 0 ]]; then 
+ 
    # Want db2gcf to timeout prior to the monitor method timeout 
... 
    gcfTimeOut=15 
 
    su - ${candidate_P_instance?} -c 
"$INSTHOME/sqllib/bin/db2gcf -t ${gcfTimeOut?} -s -i 
${candidate_P_instance?} -i ${candidate_S_instance?} -h 
${DB2HADRDBNAME?}" 
    grc=$? 
 
    # logger -i -p debug -t $0 "su - ${candidate_P_instance?} -c 
$INSTHOME/sqllib/bin/db2gcf -t ${gcfTimeOut?} -s -i 
${candidate_P_instance?} -i ${candidate_S_instance?} -h 
${DB2HADRDBNAME?} returns $grc" 
+   else 
+      grc=10 
+   fi
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
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
Apply DB2 V9.5 FixPak 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC71074 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.09.2010
12.10.2010
12.10.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList