ha sds clear argument: Stop shared-disk replication (SQL administration API)

Use the ha sds clear argument with the admin() or task() function to stop replication to shared disk (SD) secondary servers and convert the primary server to a standard server.


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

>--"ha sds clear"--,--"primary_server"--)--;-------------------><

Element Description Key Considerations
primary_server The name of the primary server to convert to a standard server. The name must be defined in the DBSERVERNAME or DBSERVERALIASES configuration parameter, or as an Enterprise Replication group name.


Run this function on an established primary server to stop replication to the SD secondary servers.

This function is equivalent to the onmode -d clear SDS primary command.


The following example stops replication from the primary server named ids_stores to SD secondary servers:
EXECUTE FUNCTION task("ha sds clear","ids_stores");

Copyright© 2018 HCL Technologies Limited