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

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.
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 IQ-product-name Administration: Multiplex > Manage Multiplex Servers > High Availability > Coordinator Failure for information on failover.
Click Finish.