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