A Sybase IQ 15.4 multiplex database upgrade changes the way users access multiplex servers. Starting with Sybase IQ 15.4, logical servers provide the only means to access the multiplex server nodes.
Upgrading a multiplex database creates an appropriate logical server for each server-specific login policy. Login policies are updated to use a logical server configuration which provides access to the same set of multiplex servers that they did prior to upgrade.
If a login policy does not allow access to any node (such as when based setting of locked is ON and there are no multiplex server level overrides), the login policy is set to a system defined logical server, NONE, instead of creating a new logical server. NONE indicates that the login policy does not allow access to any multiplex server.
If a login policy does not have any explicit setting for 'locked' option, either at base level or multiplex server level override, then no logical server is created for this policy. Such login policy will inherit the logical server assignment of the root login policy, which provides access to the same set of servers that are accessible from the root login policy.
Membership configuration of a logical server is done is such a way that it provides access to the same multiplex nodes as the corresponding 15.x login policy. A logical membership of the coordinator is also added to the logical server if login policy allowed access to the current coordinator server.
If the login policy name exceeds 125 characters, a logical server is created with the same name as of the login policy i.e. without adding a prefix of LS_.
During the upgrade, some login policy option settings or multiplex server-level overrides are reset or removed. In the root login policy, locked and max_connections overrides are reset to default values (locked 'ON' becomes locked 'OFF'; max_connection values are reset to '10').
Settings for locked and max_connections are removed from user-defined login policies. Mutliplex server level overrides are removed from all login policies.