DB2 10.5 for Linux, UNIX, and Windows

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.