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"