Creating a Logical Server Using Interactive SQL

Create a user-defined logical server using Interactive SQL.

1. Connect to the database as a user with DBA or MPX ADMIN authority.
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);