Stopping Adaptive Server

To shut down Adaptive Server:

  1. Use isql to log in to an Adaptive Server account with System Administrator privileges:

    isql -Usa -Ppassword -Sserver_name
  2. Enter the following command to shut down the server:

    1> shutdown 
    2> go

The default for the shutdown command is with wait. The with wait option 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.

This is normal behavior.

If the message indicates that Adaptive Server is waiting for processes to complete, and you need to stop Adaptive Server immediately, you can use the shutdown with nowait command. shutdown with nowait does not wait for currently executing statements to finish, nor does it perform checkpoints in every database. Use the shutdown with nowait command only when necessary.