Designating the Failover Node

Designate the secondary server that will become the new coordinator in a failover.

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.
The multiplex coordinator is running.
You must be licensed for the Multiplex Grid option (IQ_MPXNODE), if you are running secondary servers.

Task

The designated failover node defaults to the first multiplex server added to the multiplex. If the default is not acceptable, designate a different failover node.

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 Properties, or
- From the Administration Console menu bar, select Resource > Properties.
From the left pane of the Properties window, select General.
Click Change next to the Designated Failover Node field.
Change and Apply are disabled if the coordinator is not running.
Select a node from the list and click Finish.