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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere High Availability » Using the SQL Anywhere Veritas Cluster Server agents » Configuring the SAServer agent

Configuring the SAServer agent Next Page

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;ENG=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 to Interactive SQL using the same connection string and executing the query again. You should be able to connect and execute the query successfully.