Sybase Adaptive Server, Руководство по настройке

Страница: 41 / 150

CHAPTER 2 Starting and Stopping Servers
Configuration Guide
25
2 Enter:
1> shutdown
2> go
The default for
shutdown
uses the
with wait
option
,
which allows Adaptive
Server to finish executing SQL statements or procedures, perform a checkpoint
in each database, disable new logins, and perform other shutdown tasks.
Issuing the
shutdown
command prints a message like this to the sterr file:
Server SHUTDOWN by request.The SQL Server is terminating
this process.
CT-LIBRARY error:
This is normal behavior. If the message indicates that Adaptive Server is
waiting for processes to complete, and you must stop Adaptive Server
immediately, you can use
shutdown with nowait
which neither waist for
currently executing statements to finish, nor performs checkpoints in every
database.
Note
Using the
shutdown with nowait
command is not recommended; use it
only when necessary.
Stopping Backup Server
To shut down a Backup Server:
1 Use
isql
to log in to a server with System Administrator privileges.
2 Enter:
1> shutdown SYB_BACKUP
2> go
After you shut down a Backup Server, you must wait at least 30 seconds before
restarting it.
Issuing the
shutdown
command prints a message similar to the following to the
stderr file:
Backup Server: 3.48.1.1: The Backup Server will go down
immediately.
Terminating sessions.