ASA Database Administration Guide
Database Administration Utilities
The Stop utility
Stopping a database server using the dbstop command-line utility
Server name The name of a database server running on the current machine. The database server must be started so that no permissions are required to shut it down. The personal database server starts in this mode by default. For the network database server, you must supply the -gk all option.
If you supply a server name, do not supply connection parameters as well.
For more information, see -gk server option.
Connection parameters (-c) When stopping a network server, you must supply a connection string with a user ID that has permissions to stop the server. By default, DBA permission is required on the network server, and all users can shut down a personal server, but the -gk server option can be used to change this.
The behavior of dbstop can be controlled if there are active connections on a server. If there are active connections, dbstop provides a prompt asking if you wish to shut down the server. If you specify unconditional=true, the server is shut down without prompting, even if there are active connections.
If you supply connection parameters, do not supply a server name as well.
For more information, see Connection parameters, Unconditional connection parameter [UNC], and -gk server option.
Stop database only (-d) Do not stop the database server. Instead, only stop the database specified in the connection string.
Log output messages to file (-o) Write output messages to the named file.
Operate quietly (-q) Do not print a message if the database was not running.
Do not stop if there are active connections (-x) Do not stop the server if there are still active connections to the server.
Stop without prompting (-y) Stop the server even if there are still active connections to the server.
You are running the server named myserver without a database. To stop the server, specify the utility database as a DatabaseName (DBN) connection parameter:
dbstop -c "uid=DBA;pwd=SQL;eng=myserver;dbn=utility_db"
You are running the server named myserver with the database asademo.db started. To stop the server and database:
dbstop -c "uid=DBA;pwd=SQL;eng=myserver "