Logical Servers

Logical servers provide resource provisioning for the IQ multiplex, allowing you to group together 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.
• Logical Server Administration Using Interactive SQL
  If you prefer the flexibility of scripts or are familiar with Interactive SQL from other products, use Interactive SQL to administer logical servers.
• Logical Server Administration Using Sybase Central
  If you are a new user, or more comfortable with graphical interfaces, use Sybase Central to administer logical servers.
• Logical Server Administration Using Sybase Control Center
  If you prefer a web-based tool for managing logical servers, use Sybase Control Center.
• Logical Server Access
  Multiplex servers can only be accessed by using logical servers. Login policies control user access to the logical servers.
• Login Policy Options
  You can specify a per logical server level setting for the login policy options max_connections and dqp_enabled.
• Distributed Query Processing Options
  Query execution may be distributed to all available and eligible member nodes of the logical server. Not all users connecting to a logical server may require workload distribution at the same time.
• Logical Server Configuration
  Only multiplexes support logical servers.