ha sds primary argument: Convert an SD secondary server to a primary server (SQL administration API)

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

Syntax

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

>--,--"secondary_server"--)--;---------------------------------><

Element Description Key Considerations
secondary_server The name of the SD secondary 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 an established SD secondary server to convert it to the primary server.

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

Use the ha sds primary force argument to convert an inactive SD secondary server to 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 make primary command.

Example

The following example converts an SD secondary server named ids_stores3 to the primary server:
EXECUTE FUNCTION task("ha sds primary","ids_stores3");

Copyright© 2019 HCL Technologies Limited