Manage Resources Through Logical Servers

You must use logical servers to access multiplex servers.

Logical servers provide resource provisioning for the IQ multiplex by grouping a subset of computing resources (multiplex servers) as a logical entity.

• Logical Servers Overview
  A logical server allows one or more servers of a multiplex to be grouped together to serve one or more applications or users.
• Use Built-in Logical Servers
  OPEN and SERVER are built-in logical servers that always exist; their membership is implicitly defined, and is never stored in the catalog.
• Creating a Logical Server
  Create a user-defined logical server using Interactive SQL.
• Altering a Logical Server
  Alter a user-defined logical server using Interactive SQL.
• Dropping a Logical Server
  Drop a user-defined logical server using Interactive SQL.
• Connecting to a Logical Server
  Use the LogicalServer and NodeType connection parameters to establish the logical server context for a new user connection.
• Configure Logical Server Policies
  A logical server policy is associated with each logical server. Configure logical server policy options to control behavior of all associated logical servers.
• Manage Logical Server Membership
  You can only access multiplex servers by using logical servers. Login policies control user access to the logical servers.
• Redirecting Logins
  SAP Sybase IQ provides load balancing when a user tries to log in to an overloaded node by redirecting the attempted login to a node that is less loaded in the same logical server.
• Disabling Login Redirection
  You can disable login redirection for all logical servers governed by a named logical server policy, or at the connection level.
• Login Policies
  A login policy defines the rules that SAP Sybase IQ follows to establish user connections. Each login policy is associated with a set of options called login policy options.