Load a Database

This section details the multiple methods by which Monitor loads data into the database, and the configuration options available to control the data that is loaded.

You may need to manually load checkout or denial data into the database. This will be required if importing historical checkout data that is obtained from parsing a debug log, or if reloading data for checkouts and/or denials. It can also be helpful in debugging database loading problems.

  1. To manually load the database, first setup the CLI:
    % vovproject enable licmon
  2. Change to the directory that contains the data that is to be loaded. This data is stored in the checkouts/denials data files, located in licmon.swd/data under a respective subdirectory for each data type. The data is organized into files that are named for each day that contains data
  3. After setting up the CLI, the database loader command must be executed. The available commands are vovsql_load_checkouts and vovsql_load_denials.
    vovsql_load_checkouts example:
    % vovsql_load_checkouts           licmon.swd/data/checkouts/2007*
    % vovsql_load_checkouts -force    licmon.swd/data/checkouts/2007*
    % vovsql_load_checkouts -origin 2 licmon.swd/data/checkouts/MGC/mgcld/master/2010*
    % vovsql_load_checkouts           licmon.swd/data/checkouts/@TODAY@
    
    vovsql_load_denials examples:
    % cd `vovserverdir -p data`
    % vovsql_load_denials ./denials/*/*/2008*