Controls login redirection at the connection level.
Login redirection at the logical server level must be enabled for this parameter to take effect.
[ ON | OFF ]
ON
Certain applications may need to target specific nodes within a logical server.
When you specify REDIRECT=OFF, no login redirection takes place for that connection. The connection fails if the node of the initial connection cannot satisfy the connection requirements of target logical server and requested server role.
For example, you could disable login redirection at the connection level to target nodes within the logical server that contain data in SQL Anywhere tables, which is not shared between nodes.