Configuring Logical Server Node Membership

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

Prerequisites

Database Version	Logical Server Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE MULTIPLEX system privilege.

The SAP Sybase IQ resource is authenticated and running.
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.

Be familiar with the restrictions and rules regarding which coordinator, reader, and writer nodes you can add to a logical server. In the SAP Sybase IQ documentation, see SAP Sybase IQ Administration: Multiplex > Manage Resources Through Logical Servers.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > 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
The Logical Server Properties view appears.
Note:
- When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
- If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
In the left pane, click Multiplex Nodes.
Select or clear 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 SAP Sybase IQ documentation, see SAP Sybase IQ Administration: Multiplex > Manage Multiplex Servers > High Availability > Coordinator Failure for information on failover.
Click OK.