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.
f Displays link and node-IDs during verification.
i Displays item-IDs.
k Verifies links and nodes.
l Locks each data item as it is verified.
m Suppresses all messages.
n For Windows Only: Where n 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.
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.
p Directs report to system printer via the spooler.
r Inhibits index recreation on link error.
s Suppresses display of item counter.
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 normal).
x Suppresses automatic fix of bad indexes. This option produces a report only.
z Stops processing after link and node verification.

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.

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

Example(s)

Verifies the index on attribute 1 of the entity file.

verify-index entity a1

Verifies all indexes in the entity file.

verify-index entity * (o