Environment Details: Two node (AIX and Linux) DB2 HADR v10.5 * TSAMP v3.2.2 and v4.1
Description: TSAMP is configured to handle automation of two node HADR setup. Network tie-breaker is defined. Tie-breaker IP is a third IP outside the two node network configuration. I.e Network switch IP address * netmon.cfg configured to have same IP as Tie-breaker.
Now when there is a network problem, to resolve the quorum, if TSAMP is unable to reach tie-breaker and also none of the IP in netmon.cfg what happens in this case.
Also, is it possible to have a two different type of tie-breaker for a given cluster. i.e 1) Network tie-breaker 2) Disk tie-breaker.
Thanks
Answer by Andreas.Schauberer (40) | Aug 29, 2016 at 07:25 AM
Although you can define several tiebreaker resources in the resource class IBM.TieBreaker, only one of them can be active in the cluster at the same time.
Tivoli System Automation for Multiplatforms 4.1.0 - Configuring - Configuring the tiebreaker
Answer by GilroyGonsalves21 (1) | Aug 18, 2016 at 11:58 AM
Thank you Clark for getting back.
One other point, is it possible to have two tie-breaker for single cluster of different type.
Thanks
Answer by Clark Jackson (4396) | Aug 17, 2016 at 12:53 PM
If the network tiebreaker and the other node are unreachable then the node will be rebooted due to critical resource protection.
You will see messages in syslogs with the switch to "NO_QUORUM" and since all DB2 related resources are created as Critical Resources (ProtectionMode=1)( lsrsrc -Ab IBM.Application Name ProtectionMode ) then any online resource will result in a reboot should the node lose quorum.
The netmon.cf files are principally used to prove that a local NIC is functioning and really is not going to impact quorum determination at all, so regardless of whether the IPs in the netmon.cf are pingable or not the node that loses quorum is going to be rebooted.
Manual steps equivalent to 'db2haicu -delete' for DB2 9.5 or 9.7 2 Answers
TSAMP Configuration Checker for DB2 HADR and HA Shared Disk environments 5 Answers
DB2 HADR takeover does not work as expected when also using TWS policy 1 Answer
Why there are so many entries to hadrV10_monitor.ksh in messages log? 1 Answer