A multiplex requires a designated failover node to take over as coordinator if the current coordinator is not running. This node must be used 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. To change the failover node, see Designating failover node (Sybase Central) and “Designating failover node (Interactive SQL)”.
