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	You must have one of: DBA authority MULTIPLEX ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE MULTIPLEX system privilege.

The SAP Sybase IQ resource is authenticated and running.
You must be licensed for the Multiplex Grid option (IQ_MPXNODE), if you are 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 IQ-product-name 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, expand IQ Servers > Multiplex Management, and then select 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 you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
- If you do not have privileges to modify properties, SAP 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 IQ-product-name Administration: Multiplex > Manage Multiplex Servers > High Availability > Coordinator Failure for information on failover.
Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.