Configure the Historian Database
This section describes how to configure the Historian
database. RTView EM
is delivered with HSQLDB as the default database. To
use the Historian database you deploy an alternate database
that is accessible via JDBC, configure the database connection by editing a
configuration file and enable the Historian database. In RTView
EM, the Historian, by default, is configured
so that almost all Data Servers share the
same database.
The following figure illustrates the RTView EM components
that are the subject of this section.
At this
point you have:
To configure the Historian database:
Perform the steps described in
Configure the Central Server Database
to setup the Alert Historian using the following Historian-specific instructions:
Property File
Edit the emcommon.properties file (rather than the the central.properties
file), located in your project directory/conf
directory. In the
emcommon.properties file under the HISTORY CONFIGURATION, Define the
RTVHISTORY DB section, uncomment and modify the following entries as
appropriate for your environment:
| |
|
collector.sl.rtview.sql.sqldb= |
Add the required connection information. For example, for an
Oracle database you make the following edits:
ConfigCollector.sl.rtview.sql.sqldb=RTVHISTORY myusername mypassword
jdbc:oracle:thin:@myhost:9099:myinstance oracle.jdbc.driver.OracleDriver - false
false |
| |
|
historian.sl.rtview.historian.driver= |
Driver of your database. For example:
historian.sl.rtview.historian.driver=oracle.jdbc.driver.OracleDriver |
| |
|
historian.sl.rtview.historian.url= |
Full URL to use when connecting to this database
using the specified JDBC driver. |
| |
|
historian.sl.rtview.historian.username= |
User name to enter into this database when making a
connection. |
| |
|
historian.sl.rtview.historian.password= |
Password to enter into this database when making a
connection. If there is no password, use “-“. See
Encrypt Password to use an encrypted
password. |
NOTE: These instructions assume that the
Historian database connection is shared by all Data Servers. However, this
configuration might not be suitable for your system needs and architecture.
Database Table Creation
To create tables for your database, use the .sql template files
provided for each supported database platform, located in your project directory/dbconfig
directory of each installed Solution Package:
create_<package>_tables_<db>.sql
where <package> ={emsmon, bwmon, ocmon, wlm, etc.}
and <db> ={db2, mysql, oracle, sqlserver, sybase}
Proceed to
Configure Role Management.
|
