Deletes a server from the multiplex.
DROP MULTIPLEX SERVER {server-name} [drop_mpx_server_clause]
DROP MULTIPLEX SERVER writer1
Shut down each multiplex server before dropping it. This statement automatically commits.
If not already stopped as recommended, the dropped server automatically shuts down after executing this statement.
Dropping the last secondary server converts the multiplex back to simplex. After dropping the last secondary server within the multiplex, the coordinator automatically shuts down. If required, it needs to be restarted.
Clause WITH DROP MEMBERSHIP – The DROP MULTIPLEX SERVER fails with an error, when one or more logical server memberships exist for the multiplex server being dropped. Use the WITH DROP MEMBERSHIP clause to drop the multiplex server along with all of its memberships.
Clause WITH DROP LOGICAL SERVER – When dropping the last secondary server, the DROP MULTIPLEX SERVER command fails, when there are one or more user-defined logical servers. Use the WITH DROP LOGICAL SERVER clause to drop the last secondary server along with all user-defined logical servers.
Requires the MANAGE MULTIPLEX system privilege.