hadr_remote_inst - HADR instance name of the remote server configuration parameter

This parameter specifies the instance name of the remote server. High availability disaster recovery (HADR) also checks whether a remote database requesting a connection belongs to the declared remote instance.

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_inst is set to the value on member 0.
The information that is referenced by the hadr_remote_inst configuration parameter is dependant on what role the server or cluster is assigned.
  • On a primary, this configuration parameter references the instance name of the principal standby.
  • On a standby, this configuration parameter references the instance name of the primary.

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.

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.