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 » SQL Anywhere database connections » SQL Anywhere database servers » How to stop the database server

 

Stopping a database server (dbstop utility)

You can stop a database server using the dbstop utility.

Prerequisites

By default, you must have the SERVER OPERATOR system privilege. The required privileges can be changed by using the -gk database server option.

Context and remarks

The dbstop utility is useful in batch files, or for stopping a server on another computer. It requires a connection string in its command.

 Task
  • At a command prompt, execute a statement similar to the following using the dbstop utility, where server-name is the name of the server you want to stop, and user-ID and password are the connection parameters:

    dbstop -c "Server=server-name;UID=user-ID;PWD=password"

Results

The database server is stopped.

Example

Start a database server. Run the following command from the SQL Anywhere installation directory to start a server named Ottawa using the sample database:

dbsrv16 -n Ottawa "%SQLANYSAMP16%\demo.db"

Stop the server using dbstop:

dbstop -c "Server=Ottawa;UID=DBA;PWD=sql"

 See also