Dropping a Secondary Server

Remove a secondary server from a multiplex server. You can drop the designated failover server only if it is the only secondary server in the multiplex.

Prerequisites

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. All of these authorities: MULTIPLEX ADMIN authority. SPACE ADMIN authority. BACKUP authority.
SAP Sybase IQ 16.0	Requires all of: MANAGE MULTIPLEX system privilege.

The SAP Sybase IQ resource is authenticated and running.
The multiplex server’s SCC agent is registered, authenticated, and running.
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Multiplex Management > Multiplex Servers.
Select one or more multiplex servers the right pane and either:
- Click the arrow to the right of the name and select Drop Secondary Node, or
- From the Administration Console menu bar, select Resource > Drop Secondary Node
Tip: Use Shift-click or Control-click to select multiple multiplex servers.
(Optional) Select Delete the database directory. This cleans up the database directory by removing any files that belong to the server.

Warning! Use caution in selecting the option to delete files. If any of the files to be deleted are shared main files, data can be lost, and servers might not start correctly afterwards.
Click Finish.