This parameter specifies the local host for high availability
disaster recovery (HADR) TCP communication.
- Configuration type
- Database
- Applies to
-
- Database server with local and remote clients
- Database server with local clients
- Parameter type
- Configurable1
- Configurable by member in a DB2® pureScale® environment
- Default
- Null
- Upgrade Note
- If
you are upgrading from a DB2 Version 9.8 Fix Pack 4 pureScale environment
or earlier, the value of hadr_local_host is set
to the value on member 0.
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 might need
to set the registry variable DB2_HADR_NO_IP_CHECK to ON.
Refer to HADR
and Network Address Translation (NAT) support