Verifying the cluster is down

The sybcluster utility may not be able to determine whether or not the cluster is running if the cluster has crashed and left some status information in the quorum device in an inconsistent state. If you are uncertain about the status of the cluster, analyze each instance in the cluster to determine the cluster’s status.

  1. Use isql to log in to each instance in the cluster.

  2. Use sybcluster 'show cluster status' to view the status of each instance in the cluster.

  3. If sybcluster does not report that the state of all instances is 'Up' and that the heartbeat is 'Yes', the instance may be down.

  4. Use the UNIX 'ps' command on each node in the cluster to determine whether processes representing the dataserver program are running for each instance configured for that node.

  5. After starting the first instance, issue sybcluster start cluster to start all remaining instances in the cluster.

If you determine the instances are not running, unlock the cluster and restart:

start instance instance_name unlock