CHAPTER 2 Starting and Stopping Servers

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:

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.

Configuration Guide

25

Page 41
Image 41
Sybase DC35823-01-1500-04 manual Stopping Backup Server, Enter