ha rss argument: Create an RS secondary server (SQL administration API)

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

Syntax

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

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

Element Description Key Considerations
password A 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.
primary_server The name of the primary database server. The name must be defined in the DBSERVERNAME or DBSERVERALIASES configuration parameter, or as an Enterprise Replication group name.

Usage

Run this function on a standard server or a quiescent HDR secondary server to convert it an RS secondary server.

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

Example

The following example converts a standard server into an RS secondary server with a primary server named ids_stores:
EXECUTE FUNCTION task("ha rss","ids_stores");

Copyright© 2019 HCL Technologies Limited