ftlm_check_db

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