Link to home
Start Free TrialLog in
Avatar of Jim Youmans
Jim YoumansFlag for United States of America

asked on

DB2 10.5 HADR with Automatic Client Reroute

DB2 10.5 on Windows Server 2012 R2

I have a HADR setup with 2 servers.  Right now if my primary server crashed, I would log into DR server and make it the primary, then change the DNS alias to point to the DR site.  This would take between 10 and 30 minutes (roughly).

My boss has suggested that we should look at Automatic Client Reroute instead to make this quicker and more efficient.

From what I have read this has the following steps.

1. Update the alternate server setting on production to point to DR.
2. Update the alternate server setting on DR to point to production.
3. Set up time out criteria on both to control fail over.

The way I understand this is that when this is configured, the DB2 server will set up a config file on the clients with this information and when there it a communication failure, the client will start trying to connect to the alternate database.  There are also settings on the client that help to define when to switch.

So, do I have the gist of it?

Now for my questions.

1. Do any of you have experience with HADR and ACR?  If so do you recommend it?
2. Since I have HADR set up, I would still need to issue the takeover commands manually to bring up the standby server as the primary.  Is that correct?
3. Although it seems like I can control the failover timing, what I have read it not real clear.  I'm not sure I want a client to redirect to the DR server after just one communication error.  How controllable is this?
4. I reboot my DB2 server each month to apply windows updates.  The server is down for about 5-10 minutes during the reboot.  Using ACR, this would cause a failover to the DR site.  Then I would do the same for the DR server and it should fail back to the normal production server.  This sounds very similar to windows clustering.  My question is, is it really that simple?

Thank you for your time!
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial