Most solidDB server configuration settings are defined using configuration parameters. There are two solid.ini configuration files, one for the server and one for the ODBC client. Neither configuration file is obligatory. If there is no configuration file, the factory values are used. Also, all parameters do not need to be present in the solid.ini file. If a parameter is not present in the solid.ini file or if the value for a particular parameter is not set, the factory value is used.
Generally the factory values offer good performance and operability but in some cases modifying some parameter values can improve performance. You might also need to set configuration parameters to enable or disable certain functionality.
You can set the configuration parameter values by editing the solid.ini configuration file manually or, in most cases, using ADMIN COMMANDs.
Some parameter settings can also be overridden per session or per transaction by using the SQL commands SET or SET TRANSACTION. You can also define the settings per connection with the ODBC connection attributes or JDBC connection properties. The following precedence hierarchy is used (from high precedence to low precedence):
▪ SET TRANSACTION: transaction-level settings
▪ SET: session-level settings
▪ ODBC connection attributes and JDBC connection properties
▪ Parameter settings specified by the value in the solid.ini configuration file
▪ Factory value for the parameter
Additionally, you can control some solidDB server operations with the following options: