Displays information about a logical cluster.
sp_cluster 'logical', "show"[, lc_name[, {action[, state] | route[, type[, key]]}]]
lc_name – is the name of the logical cluster. If NULL is entered, summary information for all logical clusters is displayed.
action – specifies information about administrative actions: failover, failback, online, offline, deactivate.
state – is one of: cancelled, complete, or active .
route – specifies information about routes.
type – is one of: application, alias, or login.
key – is a a specific login, alias, or application name.
Example 1 Displays summary information for all configured logical clusters.
sp_cluster logical, "show", NULL
ID Name State Online Instances Connections--- ------- ------- ------------------ ---------------1 mycluster online 4 1 2 SalesLC online 2 0 3 HRLC online 1 0 4 CatchallLC offline 0 0 Logical cluster 'mycluster' is the system logical cluster. Logical cluster 'CatchallLC' is the open logical cluster. Logical Cluster Instance State Type Connections Load Score ---------------- -------- ------ ------ -------------- ----------- HRLC silk online base 0 0.01 SalesLC cotton offline failover 0 0.00 SalesLC linen online base 0 0.00 SalesLC silk offline failover 0 0.01 SalesLC wool online base 0 0.01 mycluster cotton online base 0 0.00 mycluster linen online base 0 0.00 mycluster silk online base 0 0.01 mycluster wool online base 1 0.01
Example 2 Displays a list of all outstanding actions.
sp_cluster logical, "show", NULL, action
Example 3 Displays information for the SalesLC logical cluster.
sp_cluster logical, "show", SalesLC
ID Name State Online Instances Connections ----------- -------------- ------------ ---------------- ----------- 2 OrderLC online 1 0 Instance State Type Connections Load Score Failover Gro --------------- ----------- ------- ---------- ---------- ------------ asedemo1 online base 0 0.78 NU Attribute Setting ------------------ ------------------------------------ Down Routing Mode system Failover Mode instance with fail_to_any LC Roles none Load Profile sybase_profile_oltp Login Distribution affinity Startup Mode automatic System View cluster Route Type Route Key ---------------------- ------------------ application order_app Logical cluster 'OrderLC' has no associated actions. (return status = 0)
