ftlm_check_db

Perform validation of the Monitor database. User tests are for PostgreSQL and MySQL only and cannot be combined with other options.


ftlm_check_db: Usage Message
  
  DESCRIPTION:
      Perform validation of the LicenseMonitor database.
      User tests are for PostgreSQL and MySQL only and cannot
      be combined with other options.
  USAGE:
      % ftlm_check_db [OPTIONS]
  OPTIONS:
      -h                   -- This message.
      -v                   -- Increase verbosity.
      -check               -- Check the tables.
      -fix                 -- Check and fix fix problems found in tables.
      -capacity            -- Check only capacity table.
      -defragmentids       -- Defragment
         tags/features/versions/account_types/accounts/users/hosts/loadinfo IDs.
         [MAX]              Optional, fill-in up to [MAX] holes.
                              Default: 100.
      -defragmenttable
          <TABLE>          -- Constrain -defragmentids to the specified table.
                              TABLE is one of: tags features versions
                              account_types accounts users hosts loadinfo.
                              If used, requires MAX to be specified with
                              -defragmentids.
      -dup -
      -deleteduplicates    -- Delete duplicates.
      -maxdur <TIMESPEC>   -- Delete handles longer than specified
                              time (default 180d).
      -nonascii            -- Check for non-ASCII feature names, sometimes
                              resulting from an apparent FLEXlm bug
      -outliers            -- Invalidate log-derived checkouts that are
                              unusually long compared to the average duration
                              for each feature.
      -sigmas X            -- Used with -outliers (default 8).
      -origin <ORIGIN>     -- Used with -outliers (default 'logs').
      -featurenames        -- Check and fix feature names that differ only
                              because of a dash/underscore
      -tag <TAG>           -- Constrain to check a single tag.
      -trim  <TS>          -- OBSOLETE: NO LONGER SUPPORTED
                              Use 'vovdb_util trim ...' instead.
      -start <TS>          -- Start time for checking duplicates
                              Default is one month ago.
      -end   <TS>          -- End time for checking duplicates
                              Default is 'now'.
      -testrwuser          -- Confirm DB access for RW user.
      -testrouser          -- Confirm DB access for RO user.
      -zerocots            -- Set checkout timestamp for handles with a checkout
                              timestamp of 0 equal to the checkin timestamp.
  
  COMMON EXAMPLES:
      % ftlm_check_db -check
      % ftlm_check_db -fix
      % ftlm_check_db -fix -maxdur 60d
      % ftlm_check_db -capacity
      % ftlm_check_db -deleteduplicates -fix -start 20090101
  
  LESS COMMON EXAMPLES:
      % ftlm_check_db -defragmentids 500
      % ftlm_check_db -defragmentids 500 -defragmenttable hosts
      % ftlm_check_db -outliers -sigmas 6 -origin logs
      % ftlm_check_db -testrouser