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-184.108.40.206904-240 I1912887G380 LEVEL: Warning
PID : 11185 TID : 2858305232 PROC : db2haicu
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, high avail services, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
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