Performing Coordinator Node Failover

Manually switch the coordinator role to the designated failover node.

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.
Make sure that the former coordinator process is no longer running.
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.

Warning! Performing failover while the former coordinator process is alive may cause database corruption.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers.
Select a multiplex from the right pane and either:
- Click the arrow to the right of the name and select Failover, or
- From the Administration Console menu bar, select Resource > Failover
In the Failover wizard:
1. Specify the new role for the current coordinator after failover.
2. Select a new failover node.
3. Click Finish.
4. Confirm in the popup that the coordinator is not running.