sp_cluster logical, set

Sets logical cluster rules: the open logical cluster, the failover mode, the system view, the start-up mode, and the load profile.

sp_cluster logical, "set", lc_name, {
	open | 
	failover, failover_mode |
	system_view, view_mode |
	startup, { automatic | manual } | 
	load_profile, profile_name }
        login_distribution, { affinity | "round-robin" }

lc_name – is the name of a logical cluster.

open – sets the open logical cluster. Unrouted connections are sent to the open logical cluster.

failover failover_mode – sets the failover mode of the logical cluster. Values for failover_mode are:

• instance – specifies a 1:1 failover strategy; every time a base instance fails, a failover resource is brought online.

• group – specifies that failover resources are brought online only after all base instances in the cluster fail.

system_view view_mode – sets the default system view for tasks running in the logical cluster. Values for view_mode are:

• instance – specifies that monitoring and informational tools such as sp_who, sp_lock, and monitoring tables describe an instance.

• cluster – specifies that monitoring and informational tools such as sp_who, sp_lock, and monitoring tables describe the whole cluster.

startup { automatic | manual }– sets the start-up mode of the logical cluster.

• automatic – specifies that the logical cluster is started automatically when the cluster starts.

• manual – specifies that the logical cluster must be started manually.

load_profile profile_name – specifies the load profile used to compute load scores for the logical cluster. Values for profile_name are:

• sybase_profile_oltp – is a default profile for OLTP environments supplied by Sybase.

• sybase_profile_dss – is a default profile for primarily read-only, DSS environments supplied by Sybase.

• A user-supplied profile created using sp_cluster profile.

login_distribution – specifies how the Cluster Edition distributes connections when a logical cluster spans multiple instances.

Example 33

sp_cluster logical, "set", SalesLC, load_profile, sybase_profile_oltp

Example 34

sp_cluster logical, "set", SalesLC, system_view, cluster

• Only one logical cluster can have the open property. When you set the open property to a new logical cluster, the open property is removed from the previous open logical cluster.