Creating a Logical Server

Create a user-defined logical server using Interactive SQL.

  1. Connect to the database as a user with the MANAGE MULTIPLEX system privilege.
  2. Execute a CREATE LOGICAL SERVER statement.

    For example, to create a user-defined logical server ls1 with three multiplex nodes, n1, n2, and n3, as its members:

    CREATE LOGICAL SERVER ls1 MEMBERSHIP (n1, n2, n3);
Related concepts
Logical Servers Overview
Use Built-in Logical Servers
Configure Logical Server Policies
Manage Logical Server Membership
Login Policies
Related tasks
Altering a Logical Server
Dropping a Logical Server
Connecting to a Logical Server
Redirecting Logins
Disabling Login Redirection
Related reference
CREATE LOGICAL SERVER Statement