Sybase Adaptive Server Anywhere - Page 149

Chapter 4 Database Administration Utilities
131
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 on the
command line, the server is shut down without prompting, even if there are
active connections.
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.
To stop a database named asademo on the server myserver:
dbstop -c "uid=DBA;pwd=SQL;eng=myserver;dbn=asademo"
To stop a server myserver, regardless of the databases running:
dbstop -c "uid=DBA;pwd=SQL;eng-myserver;dbn=utility_db"
Examples