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.