The solidDB^® server is designed for continuous, unattended operation and ease of deployment. It requires minimal maintenance. Administrative operations, including backups, can be performed programmatically using ADMIN COMMAND SQL extensions which can run automatically or at the request by an administrator. When necessary, you can administer solidDB^® also manually.

The solidDB^® server provides the following command-line tools for administration:

solidDB^® SQL Editor (solsql) is a console tool that you can use to issue SQL statements and solidDB^® ADMIN COMMANDs at the command prompt. You can also execute script files that contain the SQL statements.

solidDB^® Remote Control (solcon) is a console tool for administration; users with administrator rights can issue ADMIN COMMANDs at the command prompt or by executing a script file that contains the commands. With solcon, the ADMIN COMMANDs can be issued as part of the solcon startup command line.

Because only users with administrator rights can access solcon, if only solcon is deployed at a production site, the administrators cannot accidentally execute SQL statements that could change the data.

Additionally, if you are using solidDB^® with the linked access methods, the solidDB^® Server Control API (SSC API) gives the application programmatic control over task execution. The SSC API functions are available for assigning priorities for such tasks as database backup, database checkpoint, and merge of the Bonsai Tree. The priority assignment determines in what order a task is run once it is executed.

For more details on the SSC API, see solidDB^® Shared Memory Access and Linked Library Access User Guide.

You can also schedule a subset of ADMIN COMMANDs to be executed using the Srv.At connection parameter. See Entering timed commands for more details.