<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-IN" link="blue" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Just got the issue resolved.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Any case I will send the cib.xml and my custom db2 resource agent.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The existing resource agent is for HADR database, where there are two databases one running as Primary and other as standby.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I have created a script which will start/stop db2 instances with a single database on shared logical volume [HA-LVM] exclusively activated on one node.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Will mail you shortly.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Harish P <o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">
Mail</a> for Windows 10</p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="border:none;padding:0cm"><b>From: </b><a href="mailto:nwahl@redhat.com">Reid Wahl</a><br>
<b>Sent: </b>02 December 2020 12:46<br>
<b>To: </b><a href="mailto:users@clusterlabs.org">Cluster Labs - All topics related to open-source clustering welcomed</a><br>
<b>Subject: </b>Re: [ClusterLabs] Question on restart of resource during fail over</p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can you share your pacemaker configuration (i.e.,<br>
/var/lib/pacemaker/cib/cib.xml)? If you're concerned about quorum,<br>
then also share your /etc/corosync/corosync.conf just in case.<br>
<br>
Also there's a db2 resource agent already written, if you're interested:<br>
- <a href="https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2">
https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2</a><br>
<br>
On Tue, Dec 1, 2020 at 9:50 AM Harishkumar Pathangay<br>
<harishpathangay@outlook.com> wrote:<br>
><br>
> Hi,<br>
><br>
> I have DB2 resource agent scripted by myself.<br>
><br>
> It is working fine with a small glitch.<br>
><br>
><br>
><br>
> I have node1 and node2 in the cluster. No stonith enabled as I don't need one. The environment is for learning purpose only.<br>
><br>
><br>
><br>
> 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.<br>
><br>
><br>
><br>
> 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.<br>
><br>
> On the other node it is restarting the DB2 resource. So my pid of db2 changes to 3452.<br>
><br>
> This is unnecessary restart of resource which I want to avoid.<br>
><br>
> How to I get this working.<br>
><br>
><br>
><br>
> I am very new to cluster pacemaker.<br>
><br>
> Please help me so that I can create a working DB2 cluster for my learning purpose.<br>
><br>
> Also I will be blogging in my youtube channel DB2LUWACADEMY.<br>
><br>
> Please any help is of great significance to me.<br>
><br>
><br>
><br>
> 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.<br>
><br>
><br>
><br>
> How do I get this configured.<br>
><br>
><br>
><br>
> Thanks.<br>
><br>
> Harish P<br>
><br>
><br>
><br>
><br>
><br>
> Sent from Mail for Windows 10<br>
><br>
><br>
><br>
> _______________________________________________<br>
> Manage your subscription:<br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
><br>
> ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
<br>
<br>
<br>
-- <br>
Regards,<br>
<br>
Reid Wahl, RHCA<br>
Senior Software Maintenance Engineer, Red Hat<br>
CEE - Platform Support Delivery - ClusterHA<br>
<br>
_______________________________________________<br>
Manage your subscription:<br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
<br>
ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>