CREATE LS POLICY Statement

Quick Links:

Syntax

CREATE LS POLICY  <ls-policy-name> ls-option-value-list [ WITH STOP SERVER ]  
	
ls-option-value-list - (back to Syntax)
   { ls-option-name = <ls-policy-option-value> } ...

ls-option-name - (back to ls-option-value-list)
   ALLOW_COORDINATOR_AS_MEMBER
   | DQP_ENABLED 
   | ENABLE_AUTOMATIC_FAILOVER 
   | LOGIN_REDIRECTION
   | REDIRECTION_WAITERS_THRESHOLD
   | TEMP_DATA_IN_SHARED_TEMP

Parameters

(back to top)

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 Usage.

ls-policy-option-value any unspecified option inherits its value from the root logical server policy. See Usage.

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

(back to top)

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

Usage

(back to top)

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.

Option	Description
ALLOW_COORDINATOR_AS_MEMBER	Can only be set for the ROOT logical server policy. When ON (the default), the coordinator can be a member of any user-defined logical server. OFF prevents the coordinator from being used as a member of any user-defined logical servers. Values ON, OFF Default ON
DQP_ENABLED	When set to 0, query processing is not distributed. When set to 1 (the default), query processing is distributed as long as a writable shared temporary file exists. When set to 2, query processing is distributed over the network, and the shared temporary store is not used. Values 0, 1, 2 Default 1
ENABLE_AUTOMATIC_FAILOVER	Can only be set for the ROOT logical server policy. When ON, enables automatic failover for logical servers governed by specified login policy. When OFF (the default), disables automatic failover at the logical server level, allowing manual failover. Specify DEFAULT to set back to the default value. Values ON, OFF, DEFAULT Default OFF
LOGIN_REDIRECTION	When ON, enables login redirection for logical servers governed by specified login policy. When OFF (the default), disables login redirection at the logical server level, allowing external connection management. Values ON, OFF Default OFF
REDIRECTION_WAITERS_THRESHOLD	Specifies how many connections can queue before SAP IQ redirects a connection to this logical server to another server. Can be any integer value; default is 5. Values Integer Default 5
TEMP_DATA_IN_SHARED_TEMP	When ON, all temporary table data and eligible scratch data writes to the shared temporary store, provided that the shared temporary store has at least one read-write file added. You must restart all multiplex nodes after setting this option or after adding a read-write file to the shared temporary store. (If the shared temporary store contains no read-write file, or if you do not restart nodes, data is written to `IQ_SYSTEM_TEMP` instead.) When OFF (the default), all temporary table data and scratch data writes to the local temporary store. Values ON, OFF Default OFF

Standards

(back to top)

SQL–vendor extension to ISO/ANSI SQL grammar.
SAP Database products–not supported by SAP ASE.

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.