<div dir="ltr">
<p>if node is restarted, db2 is coming up, probably by autostart</p>
<p>that is what you want to keep the standby in sync ? <br>
</p>
<p>you can turn the node offline if maintenance is needed..</p>
</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 1 Dec 2020 at 18:51, Harishkumar Pathangay <<a href="mailto:harishpathangay@outlook.com">harishpathangay@outlook.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-IN">
<div class="gmail-m_6902544286922897472WordSection1">
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Hi,<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">I have DB2 resource agent scripted by myself.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">It is working fine with a small glitch.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">I have node1 and node2 in the cluster. No stonith enabled as I don't need one. The environment is for learning purpose only.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">If node one is down [power off], it is starting the resource on other node which is good. My custom resource agent doing its job. Let us say DB2 is running with pid 4567.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Now, the original node which went down is back again. I issue “pcs cluster start” on the node. Node is online. The resource also stays in the other node, which is again good. That way
unnecessary movement of resources is avoided, exactly what I want. Good but there is a issue.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">On the other node it is restarting the DB2 resource. So my pid of db2 changes to 3452.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">This is unnecessary restart of resource which I want to avoid.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">How to I get this working.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">I am very new to cluster pacemaker.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Please help me so that I can create a working DB2 cluster for my learning purpose.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Also I will be blogging in my youtube channel DB2LUWACADEMY.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Please any help is of great significance to me.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">I think it could be quorum issue. But don't know for sure, because there is only two nodes and DB2 resource needs to be active only in one node.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">How do I get this configured.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Thanks.<u></u><u></u></span></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%"><span style="color:rgb(33,33,33)">Harish P<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986" target="_blank">
Mail</a> for Windows 10</p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Manage your subscription:<br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
<br>
ClusterLabs home: <a href="https://www.clusterlabs.org/" rel="noreferrer" target="_blank">https://www.clusterlabs.org/</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature">Best Regards , Guy Przytula<br><br>Tel : +32 475 33 8186<br>mail : <a href="mailto:przytula.guy@gmail.com" target="_blank">przytula.guy@gmail.com</a></div>