<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">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I realized it can be used in standard mode only after you pointing to that.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Anyways, writing custom agent always gives me a good understanding of the resources start/stop/monitor etc…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">My custom agent still has lot of “hard coded” values, but it is meant for studying and understanding purposes rather than to put in a production machine.<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">Please find attachments.<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,</span></p>
<p class="MsoNormal">Harish P</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 15:55<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">On Wed, Dec 2, 2020 at 2:16 AM Harishkumar Pathangay<br>
<harishpathangay@outlook.com> wrote:<br>
><br>
> Just got the issue resolved.<br>
<br>
Nice work!<br>
<br>
> Any case I will send the cib.xml and my custom db2 resource agent.<br>
><br>
> The existing resource agent is for HADR database, where there are two databases one running as Primary and other as standby.<br>
<br>
HADR is only one option. There's also a standard mode:<br>
- <a href="https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2#L64-L69">
https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2#L64-L69</a><br>
<br>
I don't know much about DB2, so I'm not sure whether that would meet<br>
your needs. Based on the metadata, standard mode appears to manage a<br>
single instance (with the databases you select) on one node at a time.<br>
<br>
> 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.<br>
><br>
><br>
><br>
> Will mail you shortly.<br>
><br>
><br>
><br>
> Thanks,<br>
><br>
> Harish P<br>
><br>
><br>
><br>
> Sent from Mail for Windows 10<br>
><br>
><br>
><br>
> From: Reid Wahl<br>
> Sent: 02 December 2020 12:46<br>
> To: Cluster Labs - All topics related to open-source clustering welcomed<br>
> Subject: Re: [ClusterLabs] Question on restart of resource during fail over<br>
><br>
><br>
><br>
> 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><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>