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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database » SQL Anywhere high availability » Using the SQL Anywhere Veritas Cluster Server agents » Configuring the SAServer agent

 

Testing the SAServer agent

The following steps describe how you can test a failover situation for the SAServer agent.

 To 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.