The History Table Name Prefix field allows you to define a prefix that is added to the database table names so that the Monitor can differentiate history data between data servers when you have multiple data servers with corresponding Historians using the same solution package(s) and database. In this case, each Historian needs to save to a different table, otherwise the corresponding data server will load metrics from both Historians on startup. Once you have defined the History Table Name Prefix, you need to create the corresponding tables in your database as follows:
Locate the .sql template for your database under /rtvapm/common/dbconfig and make a copy of it
Add the value you entered for the History Table Name Prefix to the beginning of all table names in the copied .sql template
Use the copied .sql template to create the tables in your database
To add the prefix do the following:
Open the RTView Configuration Application for RTView Manager, go to RTView Manager>DATA STORAGE tab and scroll down to the bottom of the page.
In the History Table Name Prefix field, enter the desired prefix name.
your settings, then click to apply changes.