Excluding a Secondary Server

To save disk space, exclude any secondary server that will be shut down for an extended period.

Prerequisites

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority MULTIPLEX ADMIN 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

Servers that are shut down are still included in the multiplex. For each included server, the coordinator uses disk space to preserve all old versions of IQ objects changed since the server was shut down. Excluding a server allows the coordinator to ignore it during version cleanup.

Note: You cannot exclude the designated failover server, or the coordinator. Excluding a running server shuts it down.

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 from the right pane and either:
- Click the arrow to the right of the name and select Exclude Server, or
- From the Administration Console menu bar, select Resource > Exclude Server
Tip: Use Shift-click or Control-click to select multiple multiplex servers.
Click Finish.