Creates a user-defined logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
CREATE 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
CREATE LS POLICY lspolicy1 ALLOW_COORDINATOR_AS_MEMBER=ON;
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.
SQL – vendor extension to ISO/ANSI SQL grammar.
Sybase – not supported by Adaptive Server Enterprise.
Requires the MANAGE MULTIPLEX system privilege.