Filter
Top Products
CHAPTER 2 Starting and Stopping Servers
Configuration Guide 25
2Enter:
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:
1Use
isql to log in to a server with System Administrator privileges.
2Enter:
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.