Shutting down the database server

DBA permission is required to shut down the network server; all users can shut down a personal server. Normally, you should not shut down a server while it is still connected to one or more clients.

Sybase Central

In Sybase Central, do one of the following to shut down your database server.

Interactive SQL

In Interactive SQL, use the STOP ENGINE statement to stop a database server:

STOP ENGINE [database-server-name] [UNCONDITIONALLY]

The STOP ENGINE statement stops the specified database server. If you supply the UNCONDITIONALLY keyword, the database server is stopped even if there are other connections to the database server. By default, the database server will not be stopped if there are other connections to it.

You can only use a STOP ENGINE statement in Interactive SQL; you cannot use a STOP ENGINE statement in stored procedures, triggers, events, or batches.

Note In the following chapter, you will learn how to create and manage databases on your server.