DROP MULTIPLEX SERVER Statement

Deletes a server from the multiplex.

Syntax

DROP MULTIPLEX SERVER {server-
name} [drop_mpx_server_clause]

Parameters

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

Examples

  • Example 1 – 
    DROP MULTIPLEX SERVER writer1

Usage

Applies to multiplex only.

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. Please refer to section 3.3.1 for details on set of rules that apply when a multiplex is converted to a simplex.

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 logical 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.

Note: The WITH DROP LOGICAL SERVER clause is only valid when dropping the last secondary server. An error is reported otherwise.

Permissions

Must have DBA or MULTIPLEX ADMIN authority.

Parent topic: SQL Statements