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 RUNHA_<servername>.sh 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:

kill -9 `ps -ef | grep "RUNHA_<servername>.sh monitor" | grep -v grep | awk '{print $2}'`

If you do not kill the monitor process, it triggers a failover of the resources when it detects that the companion has gone down, and tries to restart the companion from either the primary or secondary node, depending on your settings for RETRY and BASIC_FAILOVER.