You can test the SADatabase agent failover from Interactive SQL.
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.
The required privileges to stop a database on the network server are determined by the database server -gd option. The default system privilege for stopping a database on the network server is SERVER OPERATOR.
Connect to the database from Interactive SQL. For example:
dbisql -c "UID=DBA;PWD=sql;Server=VCS;HOST=HostName"
Execute the following query:
SELECT * FROM Departments;
The query should execute without errors.
Suppose the database failed, and the database server running on the first system node cannot access the database file. This would create a failover of the database file to the database server started on the second system node. You can cause the database file on the first node to fail by issuing a command similar to the following command:
dbisql -q -c "UID=DBA;PWD=sql;Server=VCS1;DBN=utility_db" STOP DATABASE DEMO ON VCS1 UNCONDITIONALLY;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|