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.