To shut down Adaptive Server:
Use isql to log in to an Adaptive Server account with System Administrator privileges:
isql -Usa -Ppassword -Sserver_name
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 stderr file:
Server SHUTDOWN by request.The SQL Server is terminating this process. CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect CT-LIBRARY error: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
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 and does not perform checkpoints in every database.