Home > MultiValue Central > Online D3 Reference > TCL > tcl.verify-index

tcl.verify-index

Verb: Access/TCL, Releases: AP and AP 6.1

Verifies b-tree indices.

Syntax

verify-index file.reference a.code {(options)} verify-index file.reference * {(options)} verify-index ?

Description

verifies the integrity of one or all b-tree indices in a given filename.

'a.code' specifies the 'a (algebraic)' processing code to be used in forming the keys to the index. The processing code must include an attribute number.

The '*' (asterisk) designates all indices.

A '?' displays on-line help for this command.

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

Options

c Compares the file to the index only.

e Creates an error log. When this option is specified, the command will prompt for the error log file and item. (Only available on AP 6.1.0 and above.)

f Displays link and node-id's during verification.

i Displays item-id's.

k Verifies links and nodes.

l Locks each data item as it is verified.

m Suppresses all messages.

o Reports missing item-id's 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 indices. This is used in the case where the index contains pointers to item-id's which have been deleted. This is not normal.

x Suppresses automatic fix of bad indices. This option produces a report only.

z Stops processing after link and node verification.

Example

verify-index entity a1
Verifies the index on attribute 1 (one) of the 'entity' file.

verify-index entity * (o
Validates all indexes in the 'entity' file.

See Also

Command Name Type Description
tcl.create-index Verb: Access Creates new b-tree index.
tcl.nframe-index Verb: Access Displays total number of frames used by index or indices.
b-tree Definition Balanced-tree index.
filename.vi.dump Definition Used by 'verify-index'.
tcl.clear-index Verb: Access Clears all but null root of specified b-tree index.
tcl.indexer Verb: Access Creates b-tree indices for account.
pc.index.fdi Processing Code Maintains the root.fid of the index.
pc.a Processing Code Defines algebraic processing expression.
tcl.delete-index Verb: Access Deletes b-tree index.
basic.key Statement Locates item-id in a b-tree index.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.