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.
Control login redirection using the logical server policy options LOGIN_REDIRECTION
and REDIRECTION_WAITERS_THRESHOLD. See related reference CREATE LS POLICY
Statement.
- 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
reached its threshold of waiters in the -iqgovern
queue.
A direct connection to a server that has reached its connection
limit (-gm) is refused, not redirected, even if that
node participates in a logical server.