Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do.

You may also like...

5 Responses

  1. Sriram E says:

    In the failover testing by killing the instance and then setting the resource back, i am getting the below error.
    cope81:db2eq 180> sudo resetrsrc -s “Name =’db2_db2eq_cope81_0-rs’ AND NodeNameList = {‘cope81’}” IBM.Application
    [sudo] password for db2eq:
    2610-426 The specified resource or resource class is not currently available on node cope81.
    Tried setting up CT_MANAGEMENT_SCOPE, but still doesn’t work.

  2. Wayne Zhu says:

    I have an example of domain creation failure. It is a common error if the server is cloned:

    2017-09-05-15.29.52.874822+000 E6688133E546 LEVEL: Error
    PID : 4927 TID : 140238078834464 PROC : db2havend (db2ha)
    INSTANCE: i11 NODE : 000
    HOSTNAME: s1
    FUNCTION: DB2 UDB, high avail services, db2haCreateDomain, probe:18361
    DATA #1 : String, 248 bytes
    2632-044 The domain cannot be created due to the following errors that were detected while harvesting information from the target nodes:
    s1: 2632-068 This node has the same internal identifier as s0 and cannot be included in the domain definition.

    2017-09-05-15.29.52.875108+000 E6688680E430 LEVEL: Severe
    PID : 4846 TID : 140139498264352 PROC : db2haicu
    INSTANCE: i11 NODE : 000
    HOSTNAME: s1
    FUNCTION: DB2 UDB, high avail services, sqlhaCreateDomain2, probe:600
    MESSAGE : ECF=0x90000544=-1879046844=ECF_SQLHA_CREATE_CLUSTER_FAILED
    Create cluster failed
    DATA #1 : String, 40 bytes
    Error received from Vendor Function Call

  1. May 29, 2014

    […] 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. “Using TSA/db2haicu to automate failover Part 4: Dealing with Problems After […]

  2. May 29, 2014

    […] Most of what you’ll need to set up and test TSA using db2haicu is in my first few posts on the topic: 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. […]

  3. January 5, 2016

    […] The output I’m sharing in this blog entry comes from a system that I set up using the guidlines set forth in my HADR/TSA Series: HADR 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 *