The following steps describe how you can test a failover situation for the SAServer agent.
Connect to the database from Interactive SQL. For example:
dbisql -c "UID=DBA;PWD=sql;Server=VCS;LINKS=tcpip"
Execute the following query:
SELECT * FROM Departments;
The query should execute without errors.
Shut down the system running the database server.
Failover should occur, and all resources should start on the alternate server.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|