The only users who can stop Monitor Server are the “sa” user and the Monitor Server superuser. The superuser is the one whose account was specified in the -U and -P parameters to the Monitor Server start-up command.
In its default configuration, Monitor Server detects when Adaptive Server is not running and stops itself automatically. For more information about this feature, see “Heartbeat interval”.
To stop Monitor Server manually on a UNIX platform, connect to Monitor Server. Use the following isql command:
isql -Uusername -Ppassword -Smon_server
where:
username is either “sa” or the same user name that was specified with the -U parameter when Monitor Server was started.
password is the password associated with username.
monitor_server is the name of the Monitor Server you want to stop.
When the isql prompt appears, issue:
1> sms_shutdown 2> go
This command tells Monitor Server to complete all currently executing commands, release all held resources, and then terminate.
The no_wait option (sms_shutdown no_wait) allows shutdown to occur immediately, even when an outstanding command from another client connection exists against Monitor Server.
