Stopping Adaptive Server

Only a system administrator can shut down an Adaptive Server.

1. Use isql to log in to an Adaptive Server account with system administrator privileges:

   isql -Usa -Ppassword -Sserver_name

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 such as 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 waits for currently executing statements to finish, nor performs checkpoints in every database.

   Note: Sybase recommends that you use the shutdown with nowait command only when necessary.