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
EXECUTE FUNCTION
{
admin
| task
}
(
{
"ha sds set"
| "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");