ha sds set argument: Create a shared-disk primary server (SQL administration API)

Use the ha sds set argument with the admin() or task() function to define a primary server to replicate to shared disk (SD) secondary servers.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"ha sds set"-------+------->
                     '-task--'     '-"ha sds set force"-'   

>--,--"primary_server"--)--;-----------------------------------><

Element Description Key Considerations
primary_server The name of the database server to set as a primary 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 a standard server to define it as a primary server for SD secondary servers.

Use the ha sds set argument to define an inactive standard server as a primary server, if the SD secondary servers are connected to it.

Use the ha sds set force argument to define an inactive standard server as a primary server, whether or not any SD secondary servers are connected to it. If sessions are active, the call succeeds, but the shared disk subsystem can become corrupted.

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

Example

The following example converts a standard server named ids_stores to a primary server:
EXECUTE FUNCTION task("ha sds set","ids_stores");

Copyright© 2019 HCL Technologies Limited