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.

Syntax

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

>--"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.

Usage

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.

Example

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© 2019 HCL Technologies Limited