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
