Moves a route from one logical cluster to another.
sp_cluster logical, “alter”, lc_name, route, route_type, key_list
lc_name – is the name of a logical cluster.
route – specifies a route is to be altered.
route_type – is the type of route to be altered. Values are:
application – specifies a route for an application name to the logical cluster.
login – specifies a route for a login name to the logical cluster.
alias – specifies a route for a server name alias to the logical cluster.
key_list – is a list of applications, logins, or aliases, depending on the route type. Elements in the key list are delimited by semicolons.
Creates a route of type alias to logical cluster “lc1” with the alias “SalesLC”. Then, changes the logical cluster association of the route from “lc1” to “lc2”. The route is identified by its route type (alias) and its key (SalesLC).
sp_cluster logical, "add", "lc1", "route", "alias", "SalesLC" sp_cluster logical, "alter", "lc2", "route", "alias", "SalesLC"