Altering a Logical Server Using Interactive SQL

Alter a user-defined logical server using Interactive SQL.

  1. Connect to the database as a user with DBA or MPX ADMIN authority.
  2. Execute an ALTER LOGICAL SERVER statement.

    For example, to alter a user-defined logical server ls1 by adding multiplex nodes n4 and n5:

    ALTER LOGICAL SERVER ls1 ADD MEMBERSHIP (n4, n5) ;