Stopping Servers

You may need to stop and restart a server to install a new version of Sybase IQ, change server server-wide database options, or close an operating system session.

DBA is the default permission level required to stop a server, but you can use the -gk startup option to change the default to ALL or NONE. Setting the permission level to ALL lets all users stop the server; setting the permission level to NONE means that no one, not even the DBA, can stop the server. In a production environment, Sybase strongly recommends that only the DBA be allowed to stop the database server.

Do 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.

Server Shutdown Commands

Several commands shutdown the database server.

Command	Description
dbstop	Stops a server or database. Additional options let you stop a server, even if there are active connections. Syntax: dbstop [ options ] server-name To use dbstop to stop a server, you must specify a server-name, as well as any connection parameters you specified when you started the server. See the Utility Guide > Stopping the Database Server for complete options and syntax.
STOP ENGINE	STOP ENGINE is a SQL statement that stops a database server. Syntax: STOP ENGINE engine-name [ UNCONDITIONALLY ] The UNCONDITIONALLY argument stops a database server, even if there are client connections to the server. See Reference: Statements and Options > SQL Statements > STOP ENGINE Statement for complete options and syntax.

Command

Description

dbstop

Stops a server or database. Additional options let you stop a server, even if there are active connections.

Syntax:

dbstop [ options ] server-name

To use dbstop to stop a server, you must specify a server-name, as well as any connection parameters you specified when you started the server.

See the Utility Guide > Stopping the Database Server for complete options and syntax.

STOP ENGINE

STOP ENGINE is a SQL statement that stops a database server.

Syntax:

STOP ENGINE engine-name [ UNCONDITIONALLY ]

The UNCONDITIONALLY argument stops a database server, even if there are client connections to the server.

See Reference: Statements and Options > SQL Statements > STOP ENGINE Statement for complete options and syntax.

Server Shutdown Methods

There are several methods to shutdown or stop a server.

To stop the server from..	Do this...
Command line	Run the dbstop command.
Sybase Central	Right-click the server name and choose Stop Server.
Desktop	Right-click the server icon in the system tray, and choose Shutdown server name.
Service Manager	If you started the server as a Windows service: On the Control Panel, choose Administrative Tools > Services. Choose the Sybase IQ service, then click Stop the service.
Interactive SQL	Run the stop engine command to to stop a named database server.

Note: For other administrative issues, see System Administration Guide: Volume 1 > Sybase IQ Startup > Database Server Shutdown.