ha set standard argument: Convert an HDR server into a standard server (SQL administration API)

Use the ha set standard argument with the admin() or task() function to convert a High-Availability Data Replication (HDR) primary or secondary server to a standard server.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"ha set standard"--)--;-----><
                     '-task--'                               

Usage

Run this function on a HDR primary or secondary server to convert it to a standard server. The connection between the primary and secondary servers is dropped and replication stops. The mode of the other server in the HDR pair is not changed.

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

Example

The following example converts an HDR secondary server to a standard server:
EXECUTE FUNCTION task("ha set standard");

Copyright© 2019 HCL Technologies Limited