New syntax for shutdown

Adaptive Server version 12.5.4 includes the following new syntax for shutdown:

shutdown [srvname] [with {wait [="hh:mm:ss"] | nowait}]] 

• srvname

  • is the logical name by which the Backup Server is known in the sysservers system table. This parameter is not required when shutting down the local Adaptive Server.

• with wait

  • gracefully shuts down the Adaptive Server or Backup Server with wait is the default.

• hh:mm:ss

  • is an optional setting that specifies the maximum time the server waits for all running or sleeping processes to finish.

• with nowait

  • shuts down the Adaptive Server or Backup Server immediately, without waiting for currently executing statements to finish.

  Using shutdown with nowait can lead to gaps in IDENTITY column values.