Gather mode lets you gather all qualified connections on the system, or those connecting to an open logical cluster, and move them to another logical cluster using defined routing rules. Gather mode can automatically move the connections when a predefined action, such as online, add route, alter route, or drop route, occurs, or you can gather connections manually. Adaptive Server then looks for all connections that match the routing rules for the affected logical cluster, and migrates them to the specified logical cluster.
To manually gather the connections and move them to a named logical cluster, the syntax is:
sp_cluster logical, "gather", "lc_name"
To enable or disable the automatic gathering of connections, the syntax is:
sp_cluster logical, "set", "lc_name", "gather", {"automatic" | "manual" }
See also, “Migrating connections”.
