Gathers and migrates a group of connections to a different logical cluster. This can be done manually using “gather” or automatically using “set”.
sp_cluster logical, [ “gather”, lc_name | “set”, lc_name, “gather”, [ “automatic” | “ manual “ ] ]
gather – indicates you are gathering a set of qualified connections to migrate them to another logical cluster.
lc_name – is the name of a logical cluster.
set – indicates that you are setting the migration for a connection to either manual or automatic.
gather – indicates you are combining all connections with similar settings for a migration to another logical cluster
Automatic gather occurs when the cluster is brought online manually, routes are added or modified, or the cluster is specified as a new open cluster.
The logical cluster must be online to gather connections manually.
The logical cluster must have defined routes to gather connections.
