Control behavior of all logical servers associated with a new logical server policy.
| Database Version | Logical Server Policy Privileges |
|---|---|
| SAP Sybase IQ 15.3 and 15.4 | Not supported. |
| SAP Sybase IQ 16.0 | Requires MANAGE MULTIPLEX system privilege. |
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.
| Option | Description |
|---|---|
| Select the resource for which the logical server policy will be created. | List of multiplex servers. |
| What do you want to name the new logical server policy? | Unique name for the logical server policy. |
| What options would you like to set for this logical server policy? | (Optional.) Login Redirection – When ON, enables login redirection for logical servers governed by specified login policy. When OFF (the default), disables login redirection. Temp Data in Shared Temp – When ON (the default), all temporary table data and eligible scratch data writes to the shared temporary store if it is not empty. (If the shared temporary store contains no read-write file, data instead writes to IQ_SYSTEM_TEMP.) When OFF, all temporary table data and scratch data writes to the local temporary store. DQP Enabled – Specify DQP disabled, Enable DQP with shared temp (the default), or Enable DQP over the network. You can reset this option dynamically. Distributed query processing (DQP) over the network keeps data in memory in the temporary cache instead of in the IQ_SHARED_TEMP dbspace. The option that provides the best performance may vary by query, and depends on the performance of the network relative to the I/O system. Redirection Waiters Threshold – Specify how many connections can queue before SAP Sybase IQ redirects a connection to this logical server. Use an integer value (default is 5). |
| What would you like the comment to be for this logical server? | Enter an optional comment to simplify logical server policy administration |