ALTER LS POLICY Statement

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.

Syntax

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

Parameters

ls-policy-name – the name of the logical server policy. Specify root to modify the root logical server policy.

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 – alters the logical server policy:

ALTER LS POLICY root
ALLOW_COORDINATOR_AS_MEMBER=ON

Example 2 – alters the logical server policy and causes servers to shut down automatically when the option value changes:
```
ALTER LS POLICY root
TEMP_DATA_IN_SHARED_TEMP=ON WITH STOP SERVER
```

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.

Permissions

Requires the MANAGE MULTIPLEX system privilege.