hadr_local_host - HADR local host name configuration parameter

Configuration type

Database

Applies to

• Database server with local and remote clients
• Database server with local clients

Parameter type

• Configurable¹

Default

Null

Either a host name or an IP address can be used. If a host name is specified and it maps to multiple IP addresses, an error is returned, and HADR will not start up. If the host name maps to multiple IP addresses (even if you specify the same host name on primary and standby), primary and standby can end up mapping this host name to different IP addresses, because some DNS servers return IP address lists in non-deterministic order.

A host name is in the form: myserver.ibm.com. An IP address is in the form: "12.34.56.78".

Usage Notes

• If your primary and standby start but do not connect to one another, and no error indication appears in the DB2® diagnostic log, it could be due to subtle issues in host name resolution. If you configured HADR using host names, try again using the IP addresses instead.
• If either of the primary or standby resides in a private network behind a NAT (Network Address Translation) device, you may need to set the registry variable DB2_HADR_NO_IP_CHECK to ON. Refer to HADR and Network Address Translation (NAT) support