Altering Root Logical Server Policy Using Interactive SQL

Alter the root logical server policy of 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 LS POLICY statement:
    ALTER LS POLICY root ALLOW_COORDINATOR_AS_MEMBER=ON;