Every logical cluster possesses a set of attributes, or properties, that control different aspects of logical cluster behavior. Each attribute has a default value. You can accept the default value or change it to best suit your application environment.
To view the current settings for logical cluster attributes, use sp_cluster logical, "show". See “Viewing information about a logical cluster”.
Use sp_cluster logical to manage these attributes:
Open – specifies a logical cluster to which clients without a specific routing plan are directed.
System view – specifies whether monitoring and informational tools such as sp_who, sp_lock, and monitoring tables describe an instance in the cluster or the whole cluster
Start-up mode – specifies whether a logical cluster must be started automatically or manually.
Down-routing mode – specifies how client connections are routed if a logical cluster designated by the routing rule is not available.
Failover mode – how and when failover instances are brought online.
Fail-to-any – specifies whether any instance can be a failover resource or only a designated instance can be a failover resource.
Load profile – provides a series of weighted metrics for determining the relative workload on an instance in a logical cluster.
Login distribution mode – specifies how Adaptive Server distributes connections when a logical cluster spans multiple instances.
Action release – releases and clears these logical cluster actions—online, offline, failover, and failback—either manually or automatically after they are completed or cancelled.
Gather mode – collects groups of connections to a different logical cluster either manually or automatically when one of these predefined actions occurs—online, add route, alter route, or drop route.
Roles – indicates whether the logical cluster is “system”, “open”, or "none" if the logical cluster is neither.
