A secondary database instance is configured to store detailed measurement data replicated from the primary vRealize Hyperic database.

The secondary database contains one table, EAM_MEASUREMENT_DATA.

The secondary database has a database link to the primary vRealize Hyperic database, and five views that point to the primary vRealize Hyperic database for resource inventory data. The resource inventory data does not physically reside on the secondary database. The database link to the main database allows views on the secondary database to access inventory data in the primary Hyperic database.

The views that are required on the secondary database are

  • EAM_PLATFORM

  • EAM_SERVER

  • EAM_SERVICE

  • EAM_RESOURCE

  • EAM_MEASUREMENT_TEMPL

  • EAM_MEASUREMENT

For more information about these database tables, see vRealize Hyperic Database Table Schemas.