Consulting RDBMS Repository Performance
Before starting work in an RDBMS repository, MEGA recommends that you run the RDBMS diagnostic tool.
This tool indicates repository performance compared to optimized performance.
To run the RDBMS repository diagnostic tool:
1. Connect to HOPEX Administration and select the repository concerned.
2. Right-click the RDBMS repository concerned and select RDBMS Administration > RDBMS Diagnostics.
For more information on the RDBMS repository diagnostic tool, see deployment documentation: RDBMS Repository Installation Guide.Generating a Health File for an RDBMS Repository
HOPEX enables you to generate a file containing information on the fragmentation and the statistics of an RDBMS repository.
To generate a health file for an RDBMS repository:
1. Connect to HOPEX Administration and select the repository concerned.
2. Right-click the RDBMS repository concerned and select RDBMS Administration > Information about fragmentation and statistics.
A report file is generated with the information returned by Oracle or SQL Server on the repository health state.
Accessing the Log of Repository Changes (.EMV file)
The .EMV file contains repository changes (eg: creation, update).
To directly access the .emv file of a repository:
1. Connect to HOPEX Administration and select the repository concerned.
2. Right-click the repository concerned and select See EMV File.