Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2015

    Unanswered: Error adding Database to TSA Cluster - db2haicu

    Hi all,

    Hope you had a great Christmas

    I'm back from my holidays and just testing TSA Clustering using our 2 new test servers. It's basically replicating our production environment into a new test environment.

    I'm using two node shared disk topology.

    When running db2haicu, I am getting the following error in the last step, that is, when adding the database to the cluster.

    Adding virtual IP address 'x.x.x.x' to the domain ...
    Adding virtual IP address 'x.x.x.x' to the domain was successful.
    The following databases can be made highly available:
    Database: TESTDB
    Do you want to make all active databases highly available? [1]
    1. Yes
    2. No
    Adding database 'TESTDB' to the cluster domain ...

    The db2haicu utility hangs on like this until I kill the process.

    When I checked the DB2 diagnostic log, it is showing this entry

    2015-12-28- I187012E411 LEVEL: Warning
    PID : 6446 TID : 140568303744800 PROC : db2havend (db2ha)
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: xxxxxxxxx
    FUNCTION: DB2 UDB, high avail services, db2haAddResource, probe:11286
    DATA #1 : <preformatted>
    Error adding resource db2mnt-mnt_san_db1-rs to group db2_db2inst1_0-rg, resource handle is NOT valid

    2015-12-28- E189851E371 LEVEL: Error
    PID : 10262 TID : 140256146859808 PROC : db2haicu
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: xxxxxxxx
    FUNCTION: DB2 UDB, high avail services, SqlhaUIAppContext::getInstance, probe:100
    RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
    SQLHA API call error

    /mnt/san/db1 is the path at which I created the database.

    I have cross checked these pre-requisites for db2haicu clustering multiple times and everything seems fine.

    • /etc/hosts
    • /etc/fstab
    • preprpnode
    • db2cptsa
    • mount path filesystem type
    • mount path privileges
    • noauto option in /mnt/san/db1

    Any clue as to why this is happening?


    Vaisakh Gopal

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 27
    Not enough facts provided.
    What's the operating-system, distribution-name, patch-level?
    What's the DB2 version *and* fixpack?
    What's the version of the RSCT installed ?

  3. #3
    Join Date
    Jan 2015
    OS is Red Hat Enterprise Linux Server 6.5 (Santiago)
    DB2 AESE 10.5 FixPak 2
    TSA Version 3.2


  4. #4
    Join Date
    Apr 2006
    Provided Answers: 11
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  5. #5
    Join Date
    Apr 2012
    Provided Answers: 27
    Several APARs relating to TSA and RSCT are fixed in V10.5 fixpack 6 and higher.

    Upgrade your test environment to fixpack 6 and retry.

    To see the RSCT version (it can differ from the TSA version) use : rpm -qa | grep -E -e "rsct|src"

  6. #6
    Join Date
    Jul 2013
    Moscow, Russia
    Provided Answers: 56
    Hi Vaisakh,

    What appeared in the /var/log/messages file?
    What's the output of the samlog utility?
    Use an appropriate value with the -t option to catch only the messages during the period of time when you ran db2haicu.

Posting Permissions

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