Designated Failover Node

A multiplex requires a designated failover node to take over as coordinator if the current coordinator is not running.

You must use the failover node when performing manual failover. During multiplex creation, the first secondary server created becomes the designated failover node, but you can later designate any other secondary server as failover node.

Use the sp_iqmpxinfo procedure to display the designated failover node.

You can perform failover from the command line, from Sybase Central, or from Sybase Control Center. If you prefer a web-based management tool, use Sybase Control Center to designate a failover node or perform failover.

See the Sybase Control Center for Sybase IQ online help in SCC or at http://sybooks.sybase.com/nav/summary.do?prod=10680.

Related tasks
Designating Failover Node with Sybase Central
Designating Failover Node with Interactive SQL
Viewing the Multiplex Topology
Printing the Multiplex Topology
Related reference
sp_iqmpxinfo Procedure