<html><body><p><font size="2">Thanks Ondrej for the response. I have set the </font><tt><font size="2">PEER_WINDOW</font></tt><font size="2"> to 1000 which I guess is a reasonable value. What I am noticing is it does not wait for the </font><tt><font size="2">PEER_WINDOW</font></tt><font size="2">. Before that itself the DB goes into a REMOTE_CATCHUP_PENDING state and Pacemaker give an Error saying a DB in STANDBY/REMOTE_CATCHUP_PENDING/DISCONNECTED can never be promoted.</font><br><br><font size="2" face="Arial"><br></font><table border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td width="650" valign="bottom"><font size="2" face="Arial">Regards,</font><br><br><b><font color="#888888" face="Arial">Dileep V Nair</font></b><font size="2" face="Arial"><br>Senior AIX Administrator<br>Cloud Managed Services Delivery (MSD), India<br>IBM Cloud</font></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td width="650" colspan="2" valign="middle"><hr width="100%" size="2" align="left"></td></tr>
<tr valign="top"><td width="401"><b><font size="1" color="#466BB0" face="Arial">E-mail:</font></b><font size="1" color="#5F5F5F" face="Arial"> </font><a href="mailto:dilenair@in.ibm.com" target="_blank"><u><font size="1" color="#5F5F5F" face="Arial">dilenair@in.ibm.com</font></u></a></td><td width="249"><div align="right"><font size="1" color="#5F5F5F" face="Arial">Outer Ring Road, Embassy Manya<br>Bangalore, KA 560045<br>India</font></div></td></tr></table><br><br><img width="16" height="16" src="cid:1__=EABB08B4DFAB66668f9e8a93df938690918cEAB@" border="0" alt="Inactive hide details for Ondrej Famera ---02/01/2018 02:48:15 PM---On 02/01/2018 05:57 PM, Dileep V Nair wrote: > Now the seco"><font size="2" color="#424282">Ondrej Famera ---02/01/2018 02:48:15 PM---On 02/01/2018 05:57 PM, Dileep V Nair wrote: > Now the second issue I am facing is that when I crash</font><br><br><font size="2" color="#5F5F5F">From: </font><font size="2">Ondrej Famera <ofamera@redhat.com></font><br><font size="2" color="#5F5F5F">To: </font><font size="2">Dileep V Nair <dilenair@in.ibm.com></font><br><font size="2" color="#5F5F5F">Cc: </font><font size="2">Cluster Labs - All topics related to open-source clustering welcomed <users@clusterlabs.org></font><br><font size="2" color="#5F5F5F">Date: </font><font size="2">02/01/2018 02:48 PM</font><br><font size="2" color="#5F5F5F">Subject: </font><font size="2">Re: [ClusterLabs] Issues with DB2 HADR Resource Agent</font><br><hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br><br><br><tt><font size="2">On 02/01/2018 05:57 PM, Dileep V Nair wrote:<br>> Now the second issue I am facing is that when I crash the node were DB<br>> is primary, the STANDBY DB is not getting promoted to PRIMARY. I could<br>> fix that by adding below lines in db2_promote()<br>> <br>> 773 *)<br>> 774 # must take over forced<br>> 775 force="by force"<br>> 776<br>> 777 ;;<br>> <br>> But I am not sure of the implications that this can cause.<br>> <br>> Can someone suggest whether what I am doing is correct OR will this lead<br>> to any Data loss.<br><br><br>Hi Dileep,<br><br>As for the 'by force' implications you may check the documentation on<br>what it brings. In short: the data can get corrupted.<br><br></font></tt><tt><font size="2"><a href="https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0011553.html#r0011553__byforce">https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0011553.html#r0011553__byforce</a></font></tt><tt><font size="2"><br><br>The original 'by force peer window only' is limiting the takeover to<br>period when DB2 is within PEER_WINDOW which gives a bit more safety.<br>(the table in link above also explains how much safer it is)<br><br>Instead of changing the resource agent I would rather suggest checking<br>the PEER_WINDOW and HADR_TIMEOUT variables in DB2. They determine how<br>long it is possible to do takeover 'by force peer window only'.<br><br>-- <br>Ondrej Faměra<br>@Red Hat<br><br></font></tt><br><br><BR>
</body></html>