> -----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. > 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 Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
