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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » SQL Anywhere high availability » SQL Anywhere Veritas Cluster Server agents » SAServer agent configuration

 

Testing the SAServer agent
 Test SAServer agent failover
  1. Connect to the database from Interactive SQL. For example:

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

    SELECT * FROM Departments;

    The query should execute without errors.

  3. Shut down the system running the database server.

    Failover should occur, and all resources should start on the alternate 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.