Database

The ALERTDEFS database stores alert threshold information and optionally alert persistence information. The Central Server connects to the ALERTDEFS database to query thresholds and also to set thresholds when the user interacts with the Alert Administration page in the user interface. (If not integrated with RTView Enterprise, Data Servers make this connection to a local ALERTDEFS database.)

The RTVHISTORYdatabase stores cache data (if the Historian is enabled). The Historian connects to the RTVHISTORY database to insert cache history data and to perform data compaction. The Central Server and Data Servers connect to the RTVHISTORY database on startup to load initial history into the caches and also when the user interface asks for history data older than what is contained in the in-memory history caches.

By default, the Central Server and Historian will connect to the HSQLDB database that is included with RTView using an unsecured JDBC connection. See the Hsqldb documentation for information on configuring it for secure JDBC connections. Alternately, you can use your own database and secure the JDBC connection according to the documentation for that database.