Dropping Companion Mode

To drop companion mode, issue:

sp_companion companion_name, "drop"

Dropping companion mode is an irreversible process; you must reconfigure the Adaptive Servers companion servers before you they will failover in a high availability system and retain all the functionality that Sybase’s Failover provides. However, the nodes upon which the Adaptive Servers are running are still a monitored by the high availability subsystem.

If you drop the companion mode while the monitor script is running, the script continues to monitor the server for any down or hung instances. If you plan to shutdown the server and do not want the node to failover, you need to kill the monitor process by issuing:

/usr/sbin/cmhaltsrv service_name

For example, to halt the service for primary companion MONEY1:

/usr/sbin/cmhaltsrv MONEY1

Alternatively, you can halt the package, reactivate the volume group, and then restart the companion only.

If you do not kill the monitor process and it detects that the companion has gone down, it triggers a failover to the secondary node. It restarts the primary companion on the secondary node depending on your settings for BASIC_FAILOVER.