hadr_remote_host - HADR remote host name configuration parameter
This parameter specifies the TCP/IP host name or IP address of the remote high availability disaster recovery (HADR) database server.
- Configuration type
- Database
- Applies to
-
- Database server with local and remote clients
- Database server with local clients
- Parameter type
- Configurable1
- 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_remote_host is set to the value on member 0.
The information that is referenced by the hadr_remote_host configuration
parameter is dependant on what role the server or cluster is assigned.
- On a primary, this configuration parameter references the host
of the principal standby. In a Db2
pureScale® environment,
it contains a pipe-delimited (
|
) list of all addresses (hosts and ports) in the standby cluster. - On a standby, this configuration parameter references the host
of the primary. In a Db2
pureScale environment,
it contains a pipe-delimited (
|
) list of all addresses (hosts and ports) in the primary cluster.
Unless you are using the Db2 pureScale feature, this parameter must have a non-NULL value in order to set up HADR. This parameter is under automatic configuration when the hadr_target_list configuration parameter is set, but you should still ensure that it has the correct value in case the integrated cluster manager, IBM® Tivoli® System Automation for Multiplatforms (SA MP), picks up the incorrect value before it is automatically reconfigured.
Similar to hadr_local_host, this parameter must map to only one IP address.
1 Changes
to this parameter take effect on database activation. If the database
is already online, you can have changes take effect by stopping and
restarting HADR on the primary database.