IBM Support

ITCO restrictions while setting db2haicu

Question & Answer


Question

db2haicu setup fails even apparently all the prequisites are met

Cause

While stting up db2haicu ,sometimes it is observed as it fails with following message

The HADR database TBSM cannot be added to the cluster because the standby instance is not configured in the domain. Run db2haicu on the standby instance to configure it into the cluster.

Also we can observe following messages in db2diag.log

db2haicu Related Error Messages From db2diag:                 2016-09-04-10.08.10.378807+180 E14741317E660       LEVEL: Error
                PID     : 2883                 TID  : 140737247794976PROC : db2haicu
                INSTANCE: db2inst1             NODE : 000
                FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreateHADR, probe:900
                RETCODE : ECF=0x9000056F=-1879046801=ECF_SQLHA_HADR_VALIDATION_FAILED
                                The HADR DB failed validation before being added to the cluster
                                MESSAGE : Please verify that HADR_REMOTE_INST and HADR_REMOTE_HOST are correct
                          and in the exact format and case as the Standby instance name and
                                hostname.
                DATA #1 : String, 8 bytes


If every requirements are met ,and even both hosts are pingable to each other , try to check
syslog errors

ITBMAPPPSV02 hatsd[21777]: hadms: Loading watchdog softdog, timeout = 8000 ms.
hatsd[21777]: hadms: Found loaded iTCO_vendor_support with count 1
hatsd[21777]: hadms: iTCO_vendor_support has a use count of 1 and cannot be unloaded2 hatsd[21777]: hadms: Loading watchdog softdog, timeout = 8000 ms.
hatsd[21777]: hadms: Found loaded iTCO_vendor_support with count 1
hatsd[21777]: hadms: iTCO_vendor_support has a use count of 1 and cannot be unloaded

The reason is ITCO_vendor_support is enabled in either or both the hosts.

There is a prequisite with ITCO module.

This db2haicu prerequisite is documented in the Knowledge Center here:
http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.ha.doc/doc/r0051896.html

Answer

As a workaround ,disable the ITCO_module on both hosts and then run "db2haicu -delete" on both hosts and re-run db2haicu on the standby and then on the primary.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - Cluster Management","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21990572

Page Feedback