Deletes a server from the multiplex.
Syntax
DROP MULTIPLEX SERVER {<server-name>} [drop_mpx_server_clause]
drop_mpx_server_clause
{ WITH DROP MEMBERSHIP | WITH DROP LOGICAL SERVER }
Parameters
(back to top)
- 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
(back to top)
- Example 1 drops a multiplex server named <writer1>:
DROP MULTIPLEX SERVER writer1
Usage
(back to top)
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.