show cluster

Description

Displays configuration, log, and status information about the cluster.

Syntax

show cluster
	config
		template
	log
		[errors]
	[minseverity severity_level]
	[startdate [date_string]]
	[enddate [date_string]]
	[last number_of_lines]
	status

Parameters

status

displays status information for the cluster. Values are:

  • Up

  • Down

  • Undefined

  • Invalid

  • Start

  • Init

  • Quiesce

log

displays logs from all instances in the cluster.

errors [ minseverity severity_level ]

display log file entries for errors. (Optional) Limits displayed error entries to a severity level and above.

NoteError severities_level is an attribute of Adaptive Server error messages, not sybcluster messages.

startdate [date_string ]

display log file entries that occur on and after the date specified. The format for date_string is: mm:dd:yy.

If you do not specify a startdate or enddate date_string, the default is the current date (today).

enddate [ date_string ]

display log file entries that occur on or before the date specified.

last num_lines

limits the number of lines displayed, counting backward from the last line in the log files.

config

displays configuration information for the cluster:

  • Maximum number of instances

  • Installation mode: shared or private

  • Primary and secondary protocols

  • Trace flags set

  • Location and name of the quorum device

  • LDAP information, if LDAP is configured

  • Location and name of the master device

template

displays formatted configuration information for the cluster.

Examples

Example 1

Displays current configuration and other information about the default cluster:

show cluster status
Id   Name      Node    State   Heartbeat
-----------------------------------------
1   ase1      blade1   Up      Yes
2   ase2      blade2   Up      Yes
3   ase3      blade3   Down    No

Example 2

Displays configuration information—including LDAP, if it is configured—for the default cluster configured for shared installation mode:

show cluster config

**Cluster configuration for "mycluster" **
    Installation Mode shared
    Interfaces Path "/work2/sybase/ASE-15_0/"
    Trace Flags:
        15556
    Maximum Instances "4"
    Quorum "/dev/raw/raw101"
    Master Device
        "/dev/raw/raw102"
    logfile ase1 /work2/sybase/ASE-15_0/install/
        ase1.log
    run_parameters ase1 null
    logfile ase2 /work2/sybase/ASE-15_0/install/
        ase2.log
    run_parameters ase2 null

Primary Interconnect "udp"
    Server[1]ase1 tigger.sybase.com 26016 26031
    Server[2]ase2 christopher.sybase.com 26032 26047
Secondary Interconnect "udp"
    Server[1]ase1 tigger.sybase.com 26081 26096
    Server[2]ase2 christopher.sybase.com 26097 26112

Example 3

Displays configuration information for the default cluster configured for private installation mode:

show cluster config

**Cluster configuration for "localcluster" **
    Installation Mode "private"
    Trace Flags:
    There are no trace flags
    Maximum Instances "4"
    Quorum "/dev/raw/raw101"
    Master Device "/dev/raw/raw102"
    logfile ase1 /remote/work2/sybase/ASE-15_0/install/ase1.log
    run_parameters ase1 null
    logfile ase2 /work2/sybase/ASE-15_0/install/ase2.log
    run_parameters ase2 null

Primary Interconnect "udp"
    Server[1]ase1 tigger.sybase.com 26016 26031
    Server[2]ase2 christopher.sybase.com 26032 26047
Secondary Interconnect "udp"
    Server[1]ase1 tigger.sybase.com 26081 26096
    Server[2]ase2 christopher.sybase.com 26097 26112
LDAP server blade1 2250

Usage

show cluster status displays the results of a show instance command on each instance in the cluster.