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:
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.
Using the shutdown with nowait command
is not recommended; use it only when necessary.
