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 You must have DBA authority.
SAP Sybase IQ 16.0 You must have all of:
  • MANAGE MULTIPLEX system privilege
  • SERVER OPERATOR system privilege
  • BACKUP DATABASE system privilege
Warning!  Performing failover while the former coordinator process is alive may cause database corruption.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, select IQ Servers.
  3. 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.
  4. Select the new role for the current coordinator.
    Action to take Description
    Drop it Indicate if the server files are to be deleted when the coordinator is dropped.
    Keep it as reader Indicate if the reader is to be included or excluded (the default) as a secondary server. Default is to exclude. Indicate whether to perform synchronization after failover.
    Keep it as writer Indicate if the writer is to be included or excluded (the default) as a secondary server. Default is to exclude. Indicate whether to perform synchronization after failover.
    If the coordinator and designated failover node are both down, select a new coordinator and a new failover node from the eligible nodes. A node that is selected to be a coordinator cannot be the new failover node. If the new failover node is not running, you see a warning because that node may not be available if the coordinator fails.
  5. Click Finish.
  6. At the prompt to check whether the new coordinator server is running, click Yes.
  7. At the confirmation prompt, if the coordinator is confirmed to not be running, click Yes to perform the failover.
Related tasks
Designating the Failover Node
Registering and Authenticating an SAP Control Center Agent
Authenticating a Login Account for a Managed Resource
Viewing or Modifying Multiplex Server Properties