Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » SQL Anywhere Veritas Cluster Server agents » SAServer agent configuration


Testing the SAServer agent

You can test failover in the SAServer agent using VCS.


Your systems must be set up as follows to use the SQL Anywhere Veritas Cluster Server agents:

  • You must use Veritas Cluster Server 4.1 or later.

  • SQL Anywhere must be installed identically on each system node within the cluster.

  • Database files must be stored on a shared storage device that is accessible to all systems within the cluster.

  • The utility database password must be the same for all systems within the cluster.

    The SADatabase agent uses the utility database to start and stop specific database files. All systems participating in the cluster must have the same utility database password. You can set the utility database password by specifying the -su server option when starting the database server.

  • On Unix, the VCS agent is installed in $SQLANY16/vcsagent/saserver.

You must have SELECT privilege on the table you are selecting from, or the SELECT ANY TABLE system privilege.

  1. Connect to the database from Interactive SQL. For example:

    dbisql -c "UID=DBA;PWD=sql;Server=VCS;HOST=HostName"
  2. Execute the following query:

    SELECT * FROM Departments;

    The query should execute without errors.

  3. Shut down the system running the database server.

  4. Reconnect from Interactive SQL using the same connection string and executing the query again. You should be able to connect and execute the query successfully.


Failover should have occurred, and all resources should have started on the alternate server.

 See also