verify-index command

The verify-index BASIC program verifies the integrity of one or all B-tree indexes in a specified file name.

Syntax

 verify-index dict file.reference a.code{(options)}
 verify-index dict file.reference attribute.defining.item{(options)}
 verify-index dict file.reference* {(options)}
 verify-index ?

Parameter(s)

a.code Specifies the a processing code to be used in forming the keys to the index.

The processing code must include an attribute number.

* Designates all indexes.
? Displays online help for this command.
options a Verifies all indexes in the account or system.
c Compares the file to the index only.
e Creates an error log.

When this option is specified, the command prompts for the error log file and item (VME only).

f Displays link and node-IDs during verification (VME only).
i Displays item-IDs (VME only).
k Verifies links and nodes (VME only).
l Locks each data item as it is verified (VME only).
m Suppresses all messages (VME only).
n The n variable is an integer specifying a limit for the number of consecutive errors that can occur during index verification before moving on to the next index or file (FSI only).
n Affects output to the terminal only. Prevents output from pausing at the end of each (terminal) page of output.
o Reports missing item-IDs and locates items indexed in the wrong place.

While using this option makes the process run slower, it increases the reliability and effectiveness of the process (VME only).

p Directs the report to the system printer via the spooler.
r Inhibits index recreation when there is a link error (VME only).
s Suppresses display of item counter (VME only).
v Verifies that the data exists for the given indexes.

This is used in the cases where the index contains pointers to item-IDs that have been deleted; this is not typical (VME only).

x Suppresses automatic fix of bad indexes. This option produces a report only (VME only).
z Stops processing after link and node verification (VME only).

Description

With no options specified, the process examines each item in the file and verifies each of the indexes specified. A counter displays on the screen for monitoring the progress of the verify-index command.

To verify a single index, the TCL casing set by the case command must match the casing of the index.

Example(s)

Example 1

The following example verifies the index on attribute 1 of the entity file.

 verify-index entity a1

Example 2

The following example verifies all indexes in the entity file.

 verify-index entity * (o