Configuring Logical Server Node Membership

Add or remove multiplex nodes to or from the logical server.

Prerequisites

You have DBA or Multiplex Admin authority.
You are familiar with the restrictions and rules regarding which coordinator, reader, and writer nodes you can add to a logical server. In the Sybase IQ documentation, see Using Sybase IQ Multiplex > Logical Servers.

Task

In the Perspective Resources view, select a resource.
From the application menu bar, select View > Open > Administration Console.
In the left pane of the Administration Console, select Multiplex Management > Logical Servers.
Select the logical server 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
Click the Multiplex Nodes tab.
Select or unselect multiplex nodes to modify the logical server configuration.

Note: Select the FOR LOGICAL COORDINATOR node to add the current coordinator as a member. This ensures the coordinator is always available to the logical server as its member, regardless of which multiplex node plays the coordinator role. In the Sybase IQ documentation, see Using Sybase IQ Multiplex > Logical Servers for information on failover.
Click Apply.
Click OK.