Stopping SAP ASE

Only a system administrator can shut down an SAP ASE.

  1. Use isql to log in to an SAP ASE 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 SAP ASE 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 SAP ASE is waiting for processes to complete, and you must stop SAP ASE immediately, you can use shutdown with nowait which neither waits for currently executing statements to finish, nor performs checkpoints in every database.

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