Filter
Top Products
CHAPTER 2 Running Adaptive Server IQ
43
Stopping the database server
The preferred ways to stop the database server are:
• In UNIX, use the
stop_asiq utility. For details, see “Example — Stop a
server with stop_asiq”.
Note that when
stop_asiq is used, the following message appears:
"Please note that ’stop_asiq’ will shutdown a server
completely without regard for users connections or load
processes status. For a finer level of detail the utility ’dbstop’
has the options to control whether a server is stopped based on
active connections."
• In Windows NT, click Shutdown on the database server display or right-
click the IQ icon in the system tray and select Exit.
Normally, you should not shut down a server while it is still connected to one
or more clients. If you try this, you get a warning that any uncommitted
transactions will be lost. Disconnect or close all the clients and try again.
You can also stop the database server in the following ways:
• At the operating system command line, issue the
DBSTOP command with
appropriate parameters. Use the same parameters as when you started the
server. Without the proper connection parameters
DBSTOP doesn't know
how to connect to the server to tell it to shutdown. For details on using
DBSTOP, see Chapter 4, “Database Administration Utilities” in the
Adaptive Server IQ Reference Manual.
• In a DBISQL window or command file, issue the
STOP ENGINE
command to stop a named database server.
• In UNIX, in the window where the database server was started, type:
q
This command does not work if you have redirected input to a different
device.