Load Data

This section details the methods that Accelerator uses to load data into the database.

Automatic Loading

Checkout data files generated from sampled data will be automatically and continuously loaded if the daemon-based loader is enabled.

Job data files generated by the server are automatically and continuously loaded when the daemon-based loader is enabled. Refer to Set Up for more information.

Manual Loading

Manual loading of job data files can be accomplished by using the vovsql_load_checkouts and vovsql_load_denials command line utility.

To execute the utility, set up the CLI:
% vovproject enable vnc
The checkout loader's syntax is:

vovsql_load_checkouts: Usage Message
  
  USAGE:
      % vovsql_load_checkouts [OPTIONS] <listOfFiles>
  
  OPTIONS:
      -h              -- This help.
      -v              -- Increase verbosity.
      -q              -- Quiet.
      -origin <N>     -- Specify origin of data (see below)
      -f              -- Same as -force.
      -force          -- Force reloading of data files.
      -convert        -- Convert the old data files to current format.
  
  REQUIRED ARGUMENTS:
      <listOfFiles>   -- A list of checkout data files. Can also be specified
                         as a glob expression (e.g. checkouts/2009.12.*)
                         or can contain the tokens @TODAY@ and @YESTERDAY@.
  
  ORIGIN:
      1               -- The data comes from the sampling (default).
      2               -- The data comes from debug log parsing, to be merged.
      6               -- The data comes from debug log parsing,
                         not to be merged.
  
  EXAMPLES:
      % 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_checkouts: Usage Message

  USAGE:
      % vovsql_load_checkouts [OPTIONS] <listOfFiles>

  OPTIONS:
      -h              -- This help.
      -v              -- Increase verbosity.
      -q              -- Quiet.
      -origin <N>     -- Specify origin of data (see below)
      -f              -- Same as -force.
      -force          -- Force reloading of data files.
      -convert        -- Convert the old data files to current format.

  REQUIRED ARGUMENTS:
      <listOfFiles>   -- A list of checkout data files. Can also be specified
                         as a glob expression (e.g. checkouts/2009.12.*)
                         or can contain the tokens @TODAY@ and @YESTERDAY@.

  ORIGIN:
      1               -- The data comes from the sampling (default).
      2               -- The data comes from debug log parsing, to be merged.
      6               -- The data comes from debug log parsing,
                         not to be merged.

  EXAMPLES:
      % 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@