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

Use the ha rss delete argument with the admin() or task() function to stop replication and delete the RS secondary server.

Syntax

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

>--"ha rss delete"--,--"secondary_server"--)--;----------------><

Element Description Key Considerations
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 from an established primary server to convert the RS secondary server to a standard server and delete the RS secondary server.

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

Example

The following example deletes the RS secondary server named ids_stores2:
EXECUTE FUNCTION task("ha rss delete","ids_stores2");

Copyright© 2019 HCL Technologies Limited