Procedure 4.1. Installing and Configuring the History Database

1. Install Required Packages

   Use yum to initiate installation of the rhevm-reports-dwh package, or the rhevm-reports package if you also intend to install Red Hat Enterprise Virtualization Manager Reports. You must run this command as the root user on the system hosting the Red Hat Enterprise Virtualization Manager.
   • To install only the data warehouse package:

     # yum install rhevm-reports-dwh

   • To install both the data warehouse package and the Red Hat Enterprise Virtualization Manager Reports package:

     # yum install rhevm-reports

2. Confirm Package Installation

   The required packages are downloaded. Once all packages have been downloaded they are listed for review. You will be prompted to confirm that you wish to continue with the installation. Once you have confirmed the operation yum installs the packages. Some further configuration is, however, required before the reports functionality can be used.

3. Configure History Database

   You need to use the rhevm-dwh-setup command to configure the Extract, Transform, Load (ETL) process and database scripts used to create and maintain a working history database.
   1. You must run this command as the root user on the system hosting the Red Hat Enterprise Virtualization Manager.

      # rhevm-dwh-setup

   2. For the history database installation to take effect it is necessary to restart the ovirt-engine service. The rhevm-dwh-setup command asks you:

      Would you like to stop the ovirt-engine service? (yes|no):

      Type yes and then press Enter to proceed. The command then:

      • Stops the ovirt-engine service.
      • Creates and configures the rhevm_history database.
      • Starts the ovirt-engine service.