CREATE LS POLICY Statement

Creates a user-defined logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.

Syntax

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

Parameters

ls-policy-name – the name of the logical server policy. You can specify any identifier except root for the policy name.

ls-option-value-list – the name of the logical server policy option. See LS Policy Options for details on each option.

ls-policy-option-value – any unspecified option inherits its value from the root logical server policy. See LS Policy Options for supported values for each option

WITH STOP SERVER – automatically shuts down all servers in the logical server when the TEMP_DATA_IN_SHARED_TEMP option is changed directly or indirectly.

Applies to

Multiplex only.

Examples

Example 1 – creates a user-defined logical server policy named lspolicy1:
```
CREATE LS POLICY lspolicy1
ALLOW_COORDINATOR_AS_MEMBER=ON;
```

Usage

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.

Standards

SQL – vendor extension to ISO/ANSI SQL grammar.
Sybase – not supported by Adaptive Server Enterprise.

Permissions

Requires the MANAGE MULTIPLEX system privilege.