hadr_local_svc - HADR local service name configuration parameter

This parameter specifies the TCP service name or port number for which the local high availability disaster recovery (HADR) process accepts connections. If using port number, it must be a value in the range 1024-65535, which is the range supported by the operating systems for TCP/IP port numbers.

Configuration type
Database
Applies to
  • Database server with local and remote clients
  • Database server with local clients
Parameter type
  • Configurable1
  • Configurable by member in a Db2® pureScale® environment.
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_local_svc is set to the value on member 0.

The value for hadr_local_svc on the primary or standby database systems cannot be the same as the value of svcename or svcename +1 on their corresponding hosts.

If you are using SSL, do not set hadr_local_svc on the primary or standby database system to the same value as you set for ssl_svcename.

If this host resides in a private network behind a NAT (Network Address Translation) device, and the hadr_local_host database configuration parameter is configured with the internal and external host names, you can also configure hadr_local_svc with two service names or port numbers, one for the internal network and the other for the external network, separated by the vertical bar |, as shown in the following example:
internal_service_name | external_service_name
For more details, refer to HADR and Network Address Translation (NAT) support.
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.