Altering Root Logical Server Policy

Alter the root logical server policy of a user-defined logical server using Interactive SQL.

1. Connect to the database as a user with the MANAGE MULTIPLEX system privilege.
2. Execute an ALTER LS POLICY statement:
   To alter the root policy:

   ALTER LS POLICY root TEMP_DATA_IN_SHARED_TEMP=OFF;
   

   To alter a user-defined logical server policy:

   CREATE LS POLICY lsp1 TEMP_DATA_IN_SHARED_TEMP=OFF;
   ALTER LS POLICY lps1 TEMP_DATA_IN_SHARED_TEMP=ON;