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

The secondary database contains one table, EAM_MEASUREMENT_DATA.

The secondary database has a database link to the primary vCenter Hyperic database, and five views that point to the primary vCenter 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 vCenter Hyperic Database Table Schemas.