The SADatabase agent controls the failover of a SQL Anywhere database to another node in the cluster.
To set up the SADatabase agent
Shut down all SQL Anywhere database servers running on nodes in the cluster.
Create a directory named %VCS_HOME%\bin\SADatabase on one of the nodes in the cluster.
Copy the following files from the install-dir\SADatabase directory to the %VCS_HOME%\bin\SADatabase directory you created in Step 2:
Copy the file %VCS_HOME%\bin\VCSdefault.dll into the %VCS_HOME%\bin\SADatabase directory and rename it to SADatabase.dll.
Copy the file install-dir\SADatabase\SADatabaseTypes.cf into the %VCS_HOME%\conf\config directory.
Repeat Steps 1-5 for all systems participating in the cluster.
Start the Veritas Cluster Server Manager and enter your user name and password to connect to the cluster.
Add the SADatabase agent:
To set up a database for failover using the SADatabase agent
Add SADatabase as a resource to the service group:
On Windows, if SADatabase does not appear in the Resource Type list, you may have to add the SADatabase.xml file to the %VCS_ROOT%\cluster manager\attrpool\Win2K\400 and restart the cluster services.
DatabaseFile The location of the database file, for example, E:\demo.db.
DatabaseName A name for the database.
ServerName A name for the database server. A different server name can be supplied on each system within the cluster. The scope of the attribute should be Per System, not Global.
UtilDBpwd The utility database password used for all systems within the cluster.
This indicates that the resource is ready to be used.
Ensure that the resource dependencies are configured correctly. There are other resources that must be started/grouped together before SADatabase can be started, such as the shared disk resources and the IP address resources.
Right-click the service group, and choose Online » node-name, where node-name is the name of the computer in the cluster on which you want the resource to run.
The service group is now online.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|