Sybase 12.4.2 User Manual

CHAPTER 2    Running Adaptive Server IQ

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.