DB2 10.5 for Linux, UNIX, and Windows

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

Configurable¹

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.

¹ 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.