ha rss add argument: Add an RS secondary server to a primary server (SQL administration API)

Use the ha rss add argument with the admin() or task() function to associate a primary server with a remote standalone (RS) secondary server.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"ha rss add"-- , -"ha_alias"--+---------------+--)--;-------><
                                 '-,--"password"-'         

Element Description Key Considerations
password The password to set or to change. The password is used only during the first connection attempt. After the primary and secondary server have connected, the password cannot be changed.
ha_alias The high-availability alias of the database server to convert to an RS secondary server. The name must be defined in the HA_ALIAS configuration parameter, or as an Enterprise Replication group name.

Usage

Run this function from an established primary server to create an RS secondary server and register the RS secondary server name in the sysha database.

This function is equivalent to the onmode -d add RSS command.

Example

The following example associates a server with a high-availability alias of ids_stores2 as an RS secondary server to the primary server:
EXECUTE FUNCTION task("ha rss add","ids_stores2");

Copyright© 2019 HCL Technologies Limited