Load the Database

A need may arise 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
   • vovsql_load_denials
4. Click the links above to learn the arguments required and options supported for each command.