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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » SQL Anywhere Veritas Cluster Server agents » SADatabase agent configuration

 

Setting up the SADatabase agent

The SADatabase agent controls the failover of a SQL Anywhere database to another node in the cluster.

Prérequis

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.

The offline.pl file requires by default the SERVER OPERATOR system privilege to stop the database. You can use the -gk server command-line option to change the default behavior.

The online.pl file requires by default the SERVER OPERATOR system privilege to start the database on a network server. You can use the -gk server command-line option to change the default behavior.

 Task
  1. Shut down all SQL Anywhere database servers running on nodes in the cluster.

  2. Create a directory named %VCS_HOME%\bin\SADatabase on one of the nodes in the cluster.

  3. Copy the following files from the %SQLANY16%\VCSAgent\SADatabase directory to the %VCS_HOME%\bin\SADatabase directory you created in Step 2:

    • Online.pl
    • Offline.pl
    • Monitor.pl
    • Clean.pl
    • SADatabase.xml
  4. Copy the file %VCS_HOME%\bin\VCSdefault.dll into the %VCS_HOME%\bin\SADatabase directory and rename it to SADatabase.dll.

  5. Copy the file %SQLANY16%\VCSAgent\SADatabase\SADatabaseTypes.cf into the %VCS_HOME%\conf\config directory.

  6. Repeat steps 1-5 for all systems participating in the cluster.

  7. Start the Veritas Cluster Server Manager and enter your user name and password to connect to the cluster.

  8. Add the SADatabase agent:

    1. Click File » Import Types.

    2. Navigate to %VCS_HOME%\conf\config\, and click Import.

Résultat

The SADatabase agent is set up.

 See also