You can disable login redirection for all logical servers governed by a named
logical server policy, or at the connection level.
- Disable login redirection at the logical server level.
ALTER LS POLICY mypolicy LOGIN_REDIRECTION=OFF
You cannot enable login redirection at the connection level once you disable
it at the logical server level:
- Disable login redirection at the connection level if you do not need to affect all
servers associated with a particular logical server policy. When disabled, no
redirection occurs for the connection, and the connection fails if the node specified
cannot satisfy connection requirements of the target logical server and requested
role.
For example, if an application needs to target specific nodes within a logical
server that contains data in tables not shared between nodes, such as SQL Anywhere
tables, disable at the connection level:
dbisql -c
"uid=dba;pwd=sql;eng=mpxnode_w1;links=tcpip;redirect=off"