This section describes how to use sybcluster to display information about the cluster, instances in the cluster, and the cluster environment. For complete syntax and usage information, see Chapter 14, “The sybcluster Utility.”
You can perform the same tasks using the Adaptive Server Plug-in. See Chapter 11, “Administering Clusters with the Adaptive Server Plug-in.”
To show configuration information, primary and secondary protocol values, trace flags used, and the addresses for the quorum device and the master device, enter:
show cluster config
To view formatted configuration information for the cluster, enter:
show cluster config template
To show status and heartbeat information for each instance in the cluster, enter:
show cluster status
Status values are:
Up
Down
Undefined
Invalid
Start
Init
Quiesce
To show all log information, enter:
show cluster log
You can limit the output by specifying:
The error severity level, for example:
show cluster log minseverity 5
A date range for log entries:
show cluster log startdate 03:31:08 enddate 04:30:08
A number of lines to display from the error log, working backwards from the most recent:
show cluster log last 25
To display all UAF and JDBC connections to the cluster, enter:
show cluster connection
To display general information about the cluster and detailed information about agent connections, enter:
show session
