Use sp_cluster connection “migrate” to:
Migrate the logical cluster or instance on which a connection (or another task) is running.
Migrate an application or login to a logical cluster or instance for which it is not routed.
For example, this migrates the connection with a spid of 73 to the SalesLC logical cluster.
sp_cluster connection, "migrate", SalesLC, NULL, "73"
See the Reference Manual: Procedures.
Use sp_cluster logical to set a manual or automatic migration to another logical cluster or gather groups of connections to another logical cluster when predefined events occur. You can “gather” all qualified connections on the system or logical cluster to a designated logical cluster using the defined routing rules. The Cluster Edition looks for all connections that match the routing rules for this logical cluster, and migrates them to the specified logical cluster.
The syntax is:
sp_cluster logical, 'gather', lc_name sp_cluster logical 'set', lc_name, 'gather', 'automatic | manual'
This gathers all the defined connections to the SalesLC logical cluster:
sp_cluster logical, 'gather', SalesLC
This sets the gathering to “manual” for the SalesLC logical cluster:
sp_cluster logical 'set', SalesLC, 'gather' 'manual'
See the Reference Manual: Procedures.
