Logical Servers

A logical server allows you to group a subset of physical hardware resources together as a logical entity that appears as a single multiplex server, when it is actually one or more servers within the physical multiplex.

DBA or Multiplex Admin authority is required to work with logical servers.

In the Sybase IQ documentation, see Using Sybase IQ Multiplex > Logical Servers for logical server concepts and logical server policy concepts.

• Changing Logical Server Properties
  Edit the name of the logical server and the multiplex nodes associated with it.
• Creating a Logical Server
  Create a logical server to group multiple physical multiplex servers into a single logical entity.
• Deleting a Logical Server
  Delete a logical server from the database. Deleting a logical server does not delete its component multiplex nodes from the database.
• Configuring Logical Server Node Membership
  Add or remove multiplex nodes to or from the logical server.
• Changing the Logical Server Policy
  The only change you can make to the built-in root logical server policy to set the ALLOW_COORDINATOR_AS_MEMBER option. You cannot drop the root logical server policy or create new logical server policies.
• Altering a Logical Server Assignment
  Add one or more user-defined logical servers to a login policy. A check ensures that no membership overlap exists among the logical servers assigned to the login policy.
• Generating DDL Commands for a Logical Server
  Display the SQL code for creating a new logical server. The SQL code can be a useful reference and training tool.