DROP MULTIPLEX SERVER Statement

Syntax

DROP MULTIPLEX SERVER {server-name} [drop_mpx_server_clause] 

drop_mpx_server_clause:
   { WITH DROP MEMBERSHIP | WITH DROP LOGICAL SERVER }

Parameters

WITH DROP MEMBERSHIP – 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.

WITH DROP LOGICAL SERVER – drops the last secondary server along with all user-defined logical servers. When dropping the last secondary server, the DROP MULTIPLEX SERVER command fails, when there are one or more user-defined logical servers.
Note: The WITH DROP LOGICAL SERVER clause is only valid when dropping the last secondary server. An error is reported otherwise.

Applies to

Multiplex only.

Examples

Example 1 – drops a multiplex server named writer1:
```
DROP MULTIPLEX SERVER writer1
```

Usage

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.

Permissions

Requires the MANAGE MULTIPLEX system privilege.