To stop the database, you must prevent users from connecting to the database, disconnect all connected users, and then shut down solidDB®.
About this task
You can stop the database by using the solidDB® SQL Editor (solsql). You must include a semicolon at the end of the commands. Also, you must use single quotation marks, not double quotation marks.
Procedure
1 Prevent additional users from connecting to the database:
ADMIN COMMAND ’close’;
2 Throw out all connected users (except the one who issued the command):
ADMIN COMMAND ’throwout all’;
3 Shut down solidDB®:
ADMIN COMMAND ’shutdown’;
4 Exit from the solsql tool:
EXIT;
Note The first three commands can be replaced with this one:
admin command 'shutdown force';
Results
The solidDB® database is shut down with all previously connected users disconnected.
Note When you shut down the server, it breaks the connection to solsql, and your solsql might show an error message such as:
14519: The user was thrown out from the server; connection lost.