Stopping a database server in a mirroring system

Before performing maintenance on a database server in a high availability system, stop the database server.

Prerequisites

You must use a connection to the utility database to stop the server, so it is recommended that you include the -su server option when you started the database server.

Context and remarks

Many.

 Stop a primary, mirror, or arbiter server using the Stop Database utility (dbstop)

  • Issue a dbstop command to stop the database server.

    For example, the following command stops a database server named mirror_server1:

    dbstop -c "UID=DBA;PWD=sql;DBN=utility_db;LINKS=tcpip" mirror_server1

Results

The database server stops. Provided that at least two servers in the high availability system remain, users should be able to connect to either a copy of the database. But, depending upon which server is stopped, users may or may not be able to update the database.

Next

When you stop a primary, mirror, or arbiter server, your system continues to operate; however, to maintain high availability, you need to restart or replace the stopped database server.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1