A multiplex requires a designated failover node to take over as coordinator if the current coordinator is not running.Use the sp_iqmpxinfo procedure to display the designated failover node.
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.
The designated failover node manages automatic coordinator failover and restart.
If your system is ineligible for automatic failover, you can perform manual failover from the command line or from Sybase Control Center. For more information, see the SAP Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.