ha rss change argument: Change the password of an RS secondary server (SQL administration API)

Use the ha rss change argument with the admin() or task() function to change the connection password for the specified RS secondary server.

Syntax

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

>--"ha rss change"--,--"secondary_server"-- , -"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.
secondary_server The name of the database server to convert to an RS secondary 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 an established primary server to change the password for the connection between the primary and secondary server.

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

Example

The following example changes the password for the RS secondary server to secure:
EXECUTE FUNCTION task("ha rss change","ids_stores2","secure");

Copyright© 2019 HCL Technologies Limited