Results 1 to 3 of 3

Thread: db2haicu

  1. #1
    Join Date
    Jul 2014
    Posts
    2

    Unanswered: db2haicu

    Hi all,

    I'm trying to start a HADR + Cluster with only public network

    I did preprpnode
    I checked that hostname db2nodes.cfg and /etc/hosts are the same.
    I checked fulldomain and short name

    When I did dbhaicu in Standby serverf finishes OK with :

    Adding DB2 database partition '0' to the cluster ...
    Adding DB2 database partition '0' to the cluster was successful.
    HADR database 'MYDB' has been determined to be valid for high availability. However, the database cannot be added to the cluster from this node because db2haicu detected this node is the standby for HADR database 'MYDB'. Run db2haicu on the primary for HADR database 'MYDB' to configure the database for automated failover.
    All cluster configurations have been completed successfully. db2haicu exiting ...


    But when I try to start db2haicu on primary it stops and show this:

    There was an error with one of the issued cluster manager commands. Refer to db2diag.log and the DB2 Information Center for details.

    And db2diag shows this:

    2014-07-25-18.15.23.104904-240 I1912887G380 LEVEL: Warning
    PID : 11185 TID : 2858305232 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: hadrprin
    FUNCTION: DB2 UDB, high avail services, sqlhaGetPolicyTypeFromSysFile, probe:400
    MESSAGE : No matching instance record ... setting policy to none
    DATA #1 : unsigned integer, 4 bytes
    0

    2014-07-25-18.15.23.628352-240 E1913268G380 LEVEL: Error
    PID : 11185 TID : 2858305232 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: hadrprin
    FUNCTION: DB2 UDB, high avail services, SqlhaUIAppContext::sqlhaUIGetRootPathForAllMounts, probe:300
    RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
    SQLHA API call error

    2014-07-25-18.15.23.628778-240 E1913649G357 LEVEL: Error
    PID : 11185 TID : 2858305232 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: hadrprin
    FUNCTION: DB2 UDB, high avail services, SqlhaUIAppContext::Update, probe:1100
    RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
    SQLHA API call error

    2014-07-25-18.15.23.629100-240 E1914007G361 LEVEL: Error
    PID : 11185 TID : 2858305232 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: hadrprin
    FUNCTION: DB2 UDB, high avail services, SqlhaUIAppContext::getInstance, probe:100
    RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
    SQLHA API call error

    2014-07-25-18.15.23.629223-240 E1914369G352 LEVEL: Error
    PID : 11185 TID : 2858305232 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: hadrprin
    FUNCTION: DB2 UDB, high avail services, sqlhaUIMain, probe:900
    MESSAGE : ECF=0x90000530=-1879046864=ECF_SQLHA_NOTINITED
    Library uninitialized error



    Any Idea?

    Thanks in advance!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    did you execute db2cptsa to copy the policies ?
    maybe something went wrong with preprpnode
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2014
    Posts
    2
    Quote Originally Posted by przytula_guy View Post
    did you execute db2cptsa to copy the policies ?
    maybe something went wrong with preprpnode
    Thanks for your answer
    I was in other stuff and up to now I take this issuse again

    I fanally discovered I was doing a preprpnode with a typo

    Cheers

Posting Permissions

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