Stopping an ObjectServer from the SQL interactive interface

If you manually started an ObjectServer from the command line, you must manually stop the ObjectServer by using the SQL interactive interface. You must have the appropriate permissions to stop the ObjectServer.

To stop an ObjectServer that was started manually:

1. Connect to an ObjectServer by running the appropriate command for your operating system:

   Operating system	Command
   UNIX	$NCHOME/omnibus/bin/nco_sql [ -server servername ] [ -user username ]
   Windows	%NCHOME%\omnibus\bin\isql -S servername -U username

   In these commands, servername is the name of a local or remote ObjectServer and username is a valid user name.

   If you do not specify the -server command-line option, the SQL interactive interface connects to the NCOMS ObjectServer. If you do not specify a user name, the default is the user running the command.

   You must specify the ObjectServer name and user name.

2. Provide the requested password.
3. When the SQL prompt is displayed, enter the following commands:

   1> alter system shutdown;

   2> go

   The nco_sql command does not allow whitespace preceding the go keyword. Any whitespace causes the SQL statements to fail.