I just recently signed up for the mail list, so I think I missed that discussion. Thanks for pointing it out.

It sounds like the best approach would be to take those patches and add an 'hadr' option to the script,

//Bill

Dejan Muhamedagic wrote:
Hi,

On Sun, Jan 27, 2008 at 07:50:43PM +0100, Andreas Mock wrote:
-----Urspr?ngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Bill Whiting
Gesendet: Freitag, 25. Januar 2008 20:36
An: General Linux-HA mailing list
Betreff: [Linux-HA] Setup failover of DB2 hadr


Has anyone setup DB2 failover?
Yes, but not for DB2 HADR.

I've done it for DB2 v9 SE with necessary filesystems on SAN.
So, if one node dies, all filesystems are taken over and
db2 started on the other node.

The OCF RA in the package looks like it is setup for failover of a database with disks.
The db2 RA provided by HA package relies on having the instance
home with all db2 tools available all the time.
I changed this behaviour.

Did you see the db2 patches by Andreas Mather and the discussion?

Thanks,

Dejan

I have a DB2 HADR configuration with DB2 V9 on RedHat EL4. I want to configure heartbeat to invoke the standby database to takeover if the primary fails.
This looks to me as you need a really clone aware RA for this.
You can be sure that there are interested people out there. :-)


I think I can use the existing OCF script as a model and create a script that will provide takeover and monitoring, but I don't want to re-invent the wheel if someone else has done this already.
If you or someone else is interested I could provide my OCF RA
for DB2v9 single instance with optional moving instance home
filesystems and the possibility to handle databases in permanent
rollforward mode.


Best regards
Andreas Mock

_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to