Different modes of a companion server  Domains

Chapter 4: Modes of Failover

Determining the companion’s mode

Issue sp_companion without any options to display the mode the companion is currently in. For example:

sp_companion

Server 'MONEY1' is alive and cluster configured.
Server 'MONEY1' is configured for HA services.
Server 'MONEY1' is currently in ‘Symmetric normal’ mode.

MONEY1 is configured for symmetric failover and is running in normal companion mode.You can also use the @@cmpstate global variable to determine the mode. At the isql prompt, enter:

select @@cmpstate
Table 4-1: @@cmpstate return values

@@cmpstate

Companion mode

0

Single server

1

Reserved

2

Secondary normal

3

Secondary suspended

4

Secondary failover

5

Secondary failback

6

Reserved

7

Primary normal

8

Primary suspended

9

Primary failback

10

Reserved

11

Symmetric normal

12

Symmetric failover

13

Symmetric suspended

14

Symmetric failback

15

Reserved



Copyright © 2005. Sybase Inc. All rights reserved. Domains

View this book as PDF