Verify the integrity of an index.

  Return to Contents Page   Return to Knowledge Base   Return to JAC Home Page

Called as:

verify-index {-alorv} filename { {indexname {indexname ...}} | *}

Supported options are:

-a Verifies all indexes in the file
-l Display leaf information
-o Display overflow frame information
-r Display record keys in the index
-v Verbose mode

This command will verify an index definition in so far as it looks for internal corruption. It doesn't actually verify that the index data actually correctly cross references the data file records. Various options exist to display different information. Without any options it works silently and will only report any internal corruption it finds.

Option -a means all indexes will be verified and this can also be achieved by using * on the command line for the index name. Without the -a option (or * as index name) you must specify on the command line one or more indexes to verify.

Option -l means information about each leaf of the index is displayed. This is useful to ensure the index is properly balanced.

Option -o causes the overflow table information to be displayed.

Option -r causes all the record information to be displayed. This is the index key followed by all the record keys that share the same index value. This causes a very verbose display !

Option -v is the verbose mode and causes extra information to be displayed.

CAUTION: While this command is active a lock on an entire index is taken. Should an application try to update that index then the application will wait until the lock is released, which isn’t until the verify-index command has completed for that particular index. This means scenarios such as the one below should be used only with caution as the piping of the output into ‘more’ means the lock will be retained until the display has completed, which could be a long time if the user goes home !

% verify-index -avrl FILENAME | more

http://807199.827977/r5/knowledgebase/manuals/3.0/SecondaryIndexes/html/verify-index.htm last modified on 06/19/09 05:29 AM