HELPLIB.HLB  —  RMU72  Verify  Command Qualifiers, Indexes
    Indexes[=index-list]

    Verifies the integrity of all but disabled indexes in the
    database if you specify the Indexes or the Indexes=* qualifier;
    verifies the integrity of a specific index, or of multiple
    indexes if you provide an index list. If you list multiple
    indexes, separate the index names with a comma, and enclose the
    index list within parentheses.

    Beginning with Oracle Rdb V7.0, Oracle RMU uses a new method to
    verify indexes. In prior versions, the verify operation tried
    to retrieve the table row to which the index pointed. Beginning
    with Oracle Rdb V7.0, the verify operation creates a sorted list
    of all dbkeys for a table and a sorted list of all dbkeys in an
    index. By comparing these two lists, the verify operation can
    detect any cases of an index missing an entry for a data row. In
    addition, the verify operation runs faster. This comparison of
    dbkeys occurs at the end of the verify operation. If you specify
    the log qualifier, you see messages similar to the following to
    indicate that the comparison is occurring:

    %RMU-I-IDXVERSTR, Index data verification of logical area
     60 (DEGREES) started.
    %RMU-I-IDXVEREND, Index data verification of logical area
     60 finished.

    In addition, beginning in Oracle Rdb V7.0, when you verify an
    index with the Data qualifier (the default), Oracle RMU also
    verifies the logical areas referenced by the indexes. See Example
    5 in the Examples help entry under this command.

    See the Usage Notes entry in this command for the rules that
    determine which qualifiers can be used in combination on the same
    RMU Verify command line.

    By default, Oracle RMU does not verify indexes.

    The Indexes qualifier can be used with indirect file references.
    See the Indirect-Command-Files Help entry for more information.
Close Help