SAP Sybase IQ provides load balancing when a user tries to
log in to an overloaded node by redirecting the attempted login to a node that is less loaded
in the same logical server.
- Create a logical server policy where login redirection is enabled, for
example:
CREATE LS POLICY lsp1 LOGIN_REDIRECTION=ON
- Associate the new policy with a logical server:
ALTER LOGICAL SERVER ls1 POLICY lsp1
If login redirection is enabled and a connection is allowed,
SAP Sybase IQ redirects connections when:
- The initial connection node is not a member of the target logical server.
- The initial connection node is a member of the target logical server, but has a
role other than that requested.
- The initial node is a member of the target logical server and has the requested
role, but the user has reached the limit of maximum connections on the current
logical server member node.
Note:
SERVER is the default logical server for dbbackup and
dbstop commands.