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	You must have one of: DBA authority All of these authorities: MULTIPLEX ADMIN authority SPACE ADMIN authority BACKUP authority
SAP Sybase IQ 16.0	You must have the 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 must be licensed for the Multiplex Grid option (IQ_MPXNODE), if you are running secondary servers.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Multiplex Management, and then select 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.