To remove a SAND database instance from operation, stop the nserv process by issuing the SHUTDOWN command from an SQL session. This command can be executed only by the user DBA or another user that has been granted DBA privileges.
Executing the SHUTDOWN Command
The SHUTDOWN command has two basic forms:
SHUTDOWN also supports the KEEP CHANGE option, which is used to preserve changes made while working in Virtual or Persistent mode. For more information about the KEEP CHANGE operation, consult the Virtual Mode Operations and Persistent Mode Operations sections of the SAND CDBMS Administration Guide.
To shut down a database instance:
1. Advise all currently-connected users to commit their work (if desired) and disconnect from the instance that is to be shut down.
2. Use nisqlm to connect to the database instance as the user DBA (or another user that has been granted DBA privileges). For example:
/usr/sand/testdb> nisqlm test_alpha1 test DBA
X:\TESTDB> nisqlm test_alpha1 test DBA
3. At the nisqlm SQL prompt, type the desired SHUTDOWN command, then press ENTER. For example:
SESSION 3: test_alpha1@test
SQL:1> SHUTDOWN IMMEDIATE;
4. Issue the .exit command to exit from nisqlm.