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	Requires DBA authority.
SAP Sybase IQ 16.0	Requires all of: MANAGE MULTIPLEX system privilege. SERVER OPERATOR system privilege. BACKUP DATABASE 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 are licensed for the Multiplex Grid option (IQ_MPXNODE), if 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.
Select a node from the list and click Finish.
Click OK.