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	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires 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

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, select IQ Servers > Multiplex Management > 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.