A second point of failure for a high availability system occurs when the primary companion is already in failover mode, and another point in the system fails. Sybase Failover includes dbcc ha_admin, which addresses second points of failure.
See “dbcc options for high availability systems” for information about dbcc ha_admin syntax and a complete list of options.
After you run installhasvss on a companion server, you should re-run this script only if the stored procedures it creates are corrupted, or to install a newer version of installhasvss. dbcc ha_admin (' ', state_machine) temporarily moves the companion to single-server mode so installhasvss can safely reinstall or update the stored procedures. If you attempt to run installhasvss without running dbcc ha_admin, the companion issues the following error message:
Server is not in single-server mode.
Please run dbcc ha_admin (' ', 'state_machine', 'halt') and try again
Because dbcc ha_admin moves
the companion to single-server mode, run this command only when
there is no concurrent activity.
