Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Unanswered: DB2 HADR with TSA

    Hello,
    I was looking on the possibilities of making DB2 HADR with TSA that prevent an application from timeout and connect without disconnect from the database and move to standby when primary db is down and failover to the standby db.

    Is the above possible?

    Thank you

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    You mean automatic client reroute?
    http://www-01.ibm.com/support/knowle.../c0011558.html
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96
    Hi Andy, Thanks for reply. The Automatic Client reroute(ACR) is able handle the application reroute automatically but when an application is connecting to the primary database during a disaster strike on primary, it will get a timeout and disconnected from primary. It has to wait for the database to fail over from primary to standby, the next application that try to connect to the database will reroute automatically to the standby database via the floating ip address.

    Is there a possibilities of having an application that is connecting to primary database during the disaster strike on primary db and the application will not get timeout but stay /hold and then reroute to standby database when primary has failover to standby successfully?

  4. #4
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    If there is a disaster that causes failover then the primary is history. How can a client maintain a connection to a non-existent db.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  5. #5
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96
    yes, I agreed that is my understanding too. db2 purescale is the only option that will not disconnect/timeout the application when there is a disaster strike on the nodes.

  6. #6
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    You might want to verify your assumptions about purescale if the frame running it gets taken out by some disaster that forces a site swap.

  7. #7
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    You have to wait until the standby becomes primary.
    Have you tried to use some connection parameters like described below to avoid getting a connection timeout?
    Configuration of DB2 for Linux, UNIX, and Windows automatic client reroute support for non-Java clients
    Regards,
    Mark.

  8. #8
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    As per Mark's post, you have to read all of the stuff re client reroute. It's the job of the application to handle the reroute of the connection not DB2's job.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  9. #9
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96
    thanks guys for all the comments, it is helpful, the tuning part on client reroute should be able to seamlessly reroute but need to have a quick fail over and considering false alarm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •