IBM Support

How to resolve a HADR_CONNECT_STATUS = DISCONNECTED errno = 76 on a HADR Standby or Auxiliary standby ?

Troubleshooting


Problem

How to resolve a HADR_CONNECT_STATUS = DISCONNECTED errno = 76 on a DB2 HADR server

Symptom

Review the db2diag.log from either the DB2 Standby or the DB2 Auxiliary server for information such as:

FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduAcceptEvent, probe:20255
MESSAGE : ZRC=0xFFFFFFFF=-1
DATA #1 : <preformatted>
Failed to get peer name. Connection to Primary failed : errno = 76

or

FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveHostNameAndPort, probe:1540
MESSAGE : ZRC=0x810F0032=-2129723342=SQLO_HOST_UNKNOWN "Host unknown"

Cause

The errno = 76 from above is an error from AIX that means "AIX_ENOTCONN Socket is not connected" most likely due to having a firewall turned on for the port being used for communication between either the Standby or the Auxiliary standby to the Primary.

Environment

AIX server running DB2 HADR

Diagnosing The Problem

Engage the system admin team to investigate and confirm if there is a firewall turned on for that port denying communication from either the Standby or the Auxiliary server to the Primary.

Resolving The Problem

Once confirmed, turn off firewall for that port on the Standby or Auxiliary standby.

Related Information

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - HADR","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.1;10.5;9.7;9.8","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

swg21696649