Export Data

One function of the utility vovdb_util is to export the database into jobs data files. The exported files are saved in the vnc.swd/data/dump directory.

To execute the utility, first set up the CLI:
% vovproject enable licmon

vovdb_util


vovdb_util: Usage Message
  DESCRIPTION:
    Utilities for use with the VOV database.
  
  USAGE:
    % vovdb_util <COMMAND> [COMMON OPTIONS] [OPTIONS]
  
  COMMANDS:
    help         -- Shows help information.
    backup <dest>
                 -- Backs up the VOV database to the specified destination.
                    This command must be run on the same machine as the
                    database.  If the destination exists it must be empty.
                    The database must also be running.
    clearcfg [-noconfirm]
                 -- Resets the VOV database configuration to the initial,
                    unconfigured state.  Pass -noconfirm to skip confirmation.
    configure [-v] [-reset] [-noconfirm] <host> <root> [<port>]
                 -- Sets the host, root data path, and port for the VOV
                    database. Pass -reset to overwrite existing settings.
                    Pass -noconfirm to skip confirmation.
    showcfg      -- Prints out current VOV database configuration.
    startdb      -- Starts the VOV database.  Will restart a running database.
    status       -- Prints current VOV database status.
    stopdb       -- Stops the VOV database.
    upgrade [-noconfirm] [-noclean]
                 -- Upgrades the VOV database to use the newest version of the
                    PostgreSQL engine.  There must be enough disk space for a
                    temporary copy of the database files.  The database will be
                    offline during the upgrade.  Pass -noconfirm to skip
                    confirmation, -noclean to not delete temporary files if the
                    upgrade fails.
  
      The following commands are only supported for NetworkComputer and
      LicenseMonitor.
  
    dump [-pre201509] [-start <YYYYMMDD>] [-end <YYYYMMDD>]
                 -- Generate data files, optionally limited to the start and
                    end times specified.  Pass -pre201509 to dump the database
                    that was used prior to upgrade to 2015.09 (or beyond.)
  
    trim <YYYYMMDD>
                 -- Deletes data prior to the given date.
  
  COMMON OPTIONS:
    -v           -- Increase verbosity.

Database Export

Database export is done using the vovdb_util dump command. Pass the optional -start YYYYMMDD and -stop YYYYMMDD to restrict the dump to after the specified start date and before the specified end date.

Dump Pre-2015.09 Databases

If updating Monitor from a version prior to 2015.09, it is possible to pass the -pre201509 option to vovdb_util dump to generate data files from the old database. This can be used to save old data if the original data files are no longer present.

Checkouts

The licmon.swd/data/dump/checkouts directory contains the exported checkouts data organized by the data origination (1 = samples, 2 = debug log). The dumped data files can be loaded into a new database using the vovsql_load_checkouts utility.

When loading the sampled data, no arguments are needed. When loading the data gathered from the debug logs, the -origin 2 option needs to be passed to the utility to instruct the loader to place them in this origin in the new database.

Denials

The licmon.swd/data/dump/denials directory contains the exported denial data. The directory contains subdirectores for each tag that contains denial data in the database. The dumped data files can be loaded into a new database using the vovsql_load_denials utility.