Designating the Failover Node

Designate the secondary server as the failover node so it can take over as coordinator if the current coordinator stops running.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA authority.

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 a resource.
From the application menu bar, select View > Open > Administration Console.
From the left pane of the Administration Console, select IQ Servers > Multiplex Management > Multiplex Servers.
Select a node 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.