Available options for root and user-defined LS policies.
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.
|
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.
|
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.
|
REDIRECTION_WAITERS_THRESHOLD | Specifies how many connections can queue before
SAP Sybase IQ redirects a connection to this
logical server to another server. Can be any integer value; default is 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.
|