The Database Configuration Utility, accessed through the bathysvrconfigutil command, provides the ability to configure settings in a database without accessing the system files. The following settings can be changed:
• The username, password and hostname for the BDB superuser account (dba).
• The backup location for the database.
• The purge interval, which determines how frequently the database checks for items marked as deleted.
• The abandoned user purge interval, which determines how frequently the database tests user connections.
• The number of connections each user can make to a database.
The following is the command line format for the Database Configuration Utility and descriptions of the parameters for each of the available settings:
bathysvrconfigutil --path <value> --superuser <value> --backup <value> --purge_interval <value> --purge_interval_type <value> --user_purge_interval <value> --user_purge_interval_type <value> --write_queue_size <value>
Parameter |
| |
|---|---|---|
Long | Short | Description |
--help | -h | Display the help message (command format and descriptions of the available parameters). |
--path | The name and location of the database to be configured. | |
--superuser | The credentials used to login to the Node Manager. These can be entered in any of the following formats: • username • username/password • username@hostname • username/password@hostname If the password is not provided with the parameter (i.e. username or username@hostname parameter values) the system prompts for the password. The hostname is the name or IP address of the computer on which the Node Manager service is installed and running. When hostname is not specified, it is assumed to be the local machine. | |
--backup | The backup path for the database. | |
--purge_interval | The purge interval. | |
--purge_interval_type | The purge interval type. The options are MINUTE, HOUR, and DAY. | |
--user_purge_interval | The abandoned user purge interval. | |
--user_purge_interval_type | The abandoned user purge interval type. The options are MINUTE, HOUR, and DAY. | |
--write_queue_size | The maximum number of concurrent writes to the database, high values may cause allocation failures. | |
To use this command:
1. Open the command prompt window.
2. Go to the BDB Sever bin directory, for example
C:\Program Files\CARIS\BDB Server\<version>\bin.
3. To configure a database, enter “bathysvrconfigutil” followed by the parameters and new values for the settings you want changed.
4. To finish, press <Enter>.
The settings in the "config" file for the database are updated with the specified changes.
Example:
You need to configure a database, where:
• the database is named MyDatabase,
• the database is located in the Databases folder on the C: drive,
• the PostgreSQL installation has been moved to DatabaseServer_2 ,
• the superuser account password needs to be changed to NewPass!, and
• the purge interval needs to be 2 days.
Type the following:
bathysvrconfigutil --path "C:\Databases\MyDatabase" --superuser "dba/NewPass!@DatabaseServer_2" --purge_interval "2" --purge_interval_type "DAY"
You are now ready to register the database.
See Register a Database.