Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly

You may also like...

15 Responses

  1. Leopoldo says:

    Excelent article, congratulations!!

    Best regards from mexico

  2. Frank Ning says:

    Expecting your part 3. (I wrote the db2cptsa:-))

    • Ember Crooks says:

      Funny, I was just working on it yesterday after months of neglect. It is coming. It seems that about every 3-4 months I end up doing or helping with about 3 HADR/TSA setups in less than an month, and then nothing for another 3-4 months. Strange pattern.

  3. Dieter says:

    Hi Ember,
    when will a TSA troubleshooting part be available?

    • Ember Crooks says:

      I hope to finish writing it the last week of August. I’m not quite keeping up due to a vacation that I start tomorrow.

  4. Gerry says:

    I too look forward to part 3. I’m doing a HADR/TSA POC (first time trying TSA) and it’s fighting me every step! Latest issue is that the db2haicu just stops here:
    Create the domain now? [1]
    1. Yes
    2. No
    Creating domain hadr_melaitludbpp01_domain in the cluster …
    Creating domain hadr_melaitludbpp01_domain in the cluster was successful.
    Without progressing to the Quorum.
    If I try to rerun it errors and if I try db2haicu -delete it errors a la…
    FUNCTION: DB2 UDB, oper system services, sqloInvokeVendorFunction, probe:50
    MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF “the data does not exist”
    DIA8506C Unexpected end of file was reached.
    DATA #1 : String, 46 bytes
    Pipe read from vendor process was interrupted.

    • Ember Crooks says:

      I hope to finish writing it the last week of August. I’m a bit behind at the moment. Double check in excruciating detail the prep work that I outlined in part 1. There are scripts that come with each fixpack and the base code for uninstalling and reinstalling sam – I’ve had good luck with them.

  5. kapik says:


    I have setup the HaDR and TSA in the same way as in your article. Everything seems fine, but I am unable to perform a takeover.. I tried using db2 takeover, and rgreq ,but both failed. Actually db2 takeover is at least trying to swich roles, but after switching in shows and error and Primary comes back to the previous node.
    Takeover was working fine before configuring TSA. During configuration of TSA takeover was successful as well, but it was the last time….
    Do you have any suggestions

    • Ember Crooks says:

      If you’re on 10.5, make sure you’re on Fixpack 5. There were some issues in earlier fixpacks.

      Also, call IBM support – they should be able to help you. I have seen this issue before at my old employer, but left before it was resolved. I think it was attributed to Fixpack 3 or 4 on 10.5 in that scenario.

  6. Brian Kretch says:

    Ember: In part 1, you write that the hosts file can be either in the form “IP Shortname Longname” or “IP Longname Shortname”. You then write “You need to have HADR set up with whatever comes first – shortname or long name.” In the above configuration, the hosts file has the Shortname first. I expected the configuration setup by dbahaicu to use this name. However, the Longname was used. Can you please explain. Is DB2 still this rigid on HADR setup naming? In the original document, it is written “IP addresses don’t work.” I have seen IBM docs (including the Knowledge Center) use IP addresses (and I have used them) with no issues. Thank you for your excellent articles.

    • Ember Crooks says:

      I have now seen IP addresses in use, so I would agree that they now work. I had trouble getting them to work at the time of this article.

      I’m not sure what you mean by the longname being used by db2haicu – YOU specify what is used. If something other than the first entry in /etc/hosts works, that’s great. It is my experience that this doesn’t always work.

      • Brian Kretch says:

        Ember: Thank you for the extremely prompt response. I do appreciate it, as well as the documentation which you have written.

  7. Milos says:

    Hi Ember,
    During my initial configuration of TSA, I choose not to configure VIP address with HADR. Now I have need to use VIP address and I am curious to know if I can do it now without having to reconfigure TSA from scratch?
    Below I copied step on which I answered with NO and now I need YES 🙂

    Do you want to configure a virtual IP address for the HADR database WCSP01? [1]
    1. Yes
    2. No
    Enter the virtual IP address:
    Enter the subnet mask for the virtual IP address []

    Thanks in advance,


    • Ember Crooks says:

      Yes, you can easily use db2haicu’s maintenance mode, without reconfiguring or an outage. Just type db2haicu, and select the option to add a VIP.

  1. May 29, 2014

    […] series consists of four posts: Using TSA/db2haicu to automate failover – Part 1: The Preparation Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do. […]

Leave a Reply

Your email address will not be published. Required fields are marked *