Reference Manual
CHAPTER 4. Database Administration Utilities
The Stop utility stops a database server.
The Stop utility is a command-line utility only. In Windowing environments, you can stop a database server by clicking Close on the server window or choosing Exit from the File menu on the server window.
dbstop [switches] { name | CLIENT }
dbstopw [switches] { name | CLIENT }
Switch |
Description |
---|---|
-c "keyword=value; ..." |
Connection parameters |
-q |
Quiet mode—do not print messages |
-x |
Do not stop if there are active connections |
-y |
Stop without prompting even if there are active connections |
In UNIX, dbstop can shut down a server on any node on the network. The name is necessary to specify the name of the server that you wish to stop.
Command-line options let you control whether a server is stopped even if there are active connections.
For more information about the command-line switches, see Stop utility options.
-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 command-line option can be used to change this.
For a description of the connection parameters, see Connection parameters.
The behavior of dbstop if there are active connections on a server can be controlled. 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.
-q Operate quietly. Do not print a message if the database was not running.
-x Do not stop the server if there are still active connections to the server.
-y Stop the server even if there are still active connections to the server.
-p password Specify a password to unlock the server. If the server's keyboard is locked and no password is specified, or the specified password is incorrect, the server will not shut down.