Data Files

Checkout Data Files

The checkout data files are generated by the various Monitor parsers, and are loaded into the database by the vovsql_load_checkouts utility. They are stored in the licmon.swd/data/checkouts directory. These files should always be preserved so they can be used to recreate the Monitor database in the event of a catastrophic failure. They do not need to be located in their native location once they are at least 1 day old.

The checkout data files use the following format:
  • Comment lines begin with a #
  • One line per checkout
  • Each line is a tab separated list with the following fields:
    1. TAG
    2. NAME
    3. ACCOUNT
    4. USER
    5. HOST
    6. HANDLE
    7. DISPLAY
    8. VERSION
    9. TOKENS
    10. PID
    11. REQUEST-TIMESTAMP
    12. CHECKOUT-TIMESTAMP
    13. CHECKINTS-TIMESTAMP

Denial Data Files

The denial data files are generated by the Monitor debug log parser, and are loaded into the database by the vovsql_load_denials utility. They are stored in the licmon.swd/data/checkouts directory. These files should always be preserved so they can be used to recreate the Monitor database in the event of a catastrophic failure. They do not need to be located in their native location once they have been loaded into the database.

The denial data files use the following format:
  • No comments
  • One line per denial
  • Each line is a tab separated list with the following fields:
    1. TIMESTAMP
    2. TAG
    3. FEATURE
    4. ACCOUNT
    5. USER
    6. HOST
    7. TOKENS

Capacity Data Files

The capacity data files are generated by the ftlm_capacity utility as capacity snapshots are taken (hourly by default, as the database is loaded). Only capacity changes are written. The data files are stored in the licmon.swd/data/capacity directory. These files should always be preserved so they can be used to recreate the Monitor database in the event of a catastrophic failure. They do not need to be located in their native location once they are at least 1 day old. The ftlm_capacity utility is also used to import these files if requested to do so.

The capacity data files use the following format:
  • Comment lines begin with a #
  • One line per capacity change
  • Each line is a tab separated list with the following fields:
    1. setCapacity (procedure name that is called if file is imported)
    2. TAG
    3. FEATURE
    4. TOKENS
    5. TIMESTAMP