Creating a Logical Server

Create a logical server to group multiple physical multiplex servers into a single logical entity.

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.

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.
Click the arrow next to Logical Servers and select New.
The Create Logical Server wizard appears.

On the Logical Server Name page, specify:

Option	Description
Select the resource for which the logical server will be created.	List of available resources.
What do you want to name the new logical server?	Unique name for the logical server.
What would you like the comment to be for this logical server?	Optional comment about this logical server.

Click Next.
On the Logical Server Node Membership page, select the multiplex nodes you want to add to the logical server. You can select the coordinator node, or secondary nodes.

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 Finish.