Dropping companion mode

To drop companion mode, issue:

sp_companion companion_name, "drop"

Dropping companion mode is irreversible; you must reconfigure the Adaptive Servers companion servers to retain the failover functionality. However, the nodes upon which the Adaptive Servers are running are still monitored by the high availability system.

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 stopped instances. If you plan to shut down the server and do not want the node to fail over, 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 attempts to restart the companion from either the primary or secondary node, depending on your settings for RETRY and BASIC_FAILOVER.