The solidDB® Remote Control (solcon) is a console tool for administration; it can be used to issue ADMIN COMMANDs at the command prompt or by executing a script file that contains the commands. The ADMIN COMMANDs can be issued also as part of the solcon startup command line.
Only users with administrator rights can issue commands with solcon. Because solcon can be used to issue only ADMIN COMMANDs, it can be useful to deploy only solcon on a production node; with solcon, administrators cannot accidentally access or change data in the database by issuing SQL statements.
Note The ADMIN COMMAND 'command_name' syntax is different in solidDB® Remote Control (solcon) and in solidDB® SQL Editor (solsql). In solcon, you must give the command using the command_name only, without the prefix ADMIN COMMAND, the single quotation marks, and the line-ending semicolon.
Example: solcon
For example, in solcon, you issue the ADMIN COMMAND for backup as backup.
soliddb Remote Control to "tcp 1964" Type help for help soliddb - Version 100.0.0.0 Build 2014-11-30 (Windows 64bit MT) soliddb 100.0 Exit by giving command: exit ----------------------------------------------------------------- >backup
Example: solsql
In solsql, you issue the ADMIN COMMAND for backup as ADMIN COMMAND "backup";.
solsql: soliddb SQL Editor (teletype) - Version: 100.0.0.0 Build 2014-11-30 Connected to 'tcp 2315'. Execute SQL statements terminated by a semicolon. Exit by giving command: exit; solsql>ADMIN COMMAND 'backup';