Shutting Down SAP ASE

shutdown minimizes the amount of work that automatic recovery must do when you restart SAP ASE.

If you do not provide a server name, shutdown shuts down the SAP ASE you are using. When you issue a shutdown command, SAP ASE:

  1. Disables logins, except for system administrators

  2. Performs a checkpoint in each database, flushing pages that have changed from memory to disk

  3. Waits for currently executing SQL statements or procedures to finish

The with nowait option shuts down SAP ASE immediately. User processes are aborted, and recovery may take longer after a shutdown with nowait. You can help minimize recovery time by issuing a checkpoint command before you issue a shutdown with nowait command.

Parent topic: Shutting Down Servers