Sybase 12.4.2 manual Stopping the database server

CHAPTER 2 Running Adaptive Server IQ

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.

43