Stopping the database server

You can stop the database server by:

  • Clicking Shut Down on the database server messages window.

  • Using the dbstop utility.

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

  • Letting it shut down automatically by default when the application disconnects.

  • Pressing Q when the database server messages window has the focus on Unix.

 Stop a database server using the dbstop utility

  1. Start a database server. For example, run the following command from the SQL Anywhere installation directory to start a server named Ottawa using the sample database: 

    dbsrv12 -n Ottawa "%SQLANYSAMP12%\demo.db"

  2. Stop the server using dbstop:

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

Who can stop a database server?
Operating system session shutdown

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