Modifies some or all option values for the root logical server policy or a user-created logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
ALTER LS POLICY ls-policy-name ls-option-value-list [ WITH STOP SERVER ] ls-option-value-list: { ls-option-name = ls-policy-option-value } ... ls-option-name: ALLOW_COORDINATOR_AS_MEMBER | DQP_ENABLED | LOGIN_REDIRECTION | REDIRECTION_WAITERS_THRESHOLD | TEMP_DATA_IN_SHARED_TEMP
ALTER LS POLICY root ALLOW_COORDINATOR_AS_MEMBER=ON
ALTER LS POLICY root TEMP_DATA_IN_SHARED_TEMP=ON WITH STOP SERVER
If you want a smaller IQ_SYSTEM_TEMP dbspace, set TEMP_DATA_IN_SHARED_TEMP to ON, which writes temporary data to IQ_SHARED_TEMP instead of IQ_SYSTEM_TEMP. In a distributed query processing environment, however, setting both DQP_ENABLED and TEMP_DATA_IN_SHARED_TEMP to ON may saturate your SAN with additional data in IQ_SHARED_TEMP, where additional I/O operations against IQ_SHARED_TEMP may adversely affect DQP performance.
Requires the MANAGE MULTIPLEX system privilege.