DROP MULTIPLEX SERVER Statement

Deletes a server from the multiplex.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Permissions

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)

Applies to

Multiplex only.

Examples

(back to top)

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.

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.