DROP MULTIPLEX SERVER statement

Syntax

DROP MULTIPLEX SERVER server-name

Usage

Deletes a server from the multiplex. Sybase recommends that you shut down each multiplex server before dropping it. This statement is automatically committed.

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.

Example

DROP MULTIPLEX SERVER writer1

Permissions

Must have DBA or MULTIPLEX ADMIN authority.