Progress
Database Administration
Guide and Reference


PROUTIL IDXCHECK Qualifier

Checks Progress database indexes to determine whether an index is corrupt, and if it is, diagnoses the problem. This lets you know whether you have to perform an index rebuild before actually running PROUTIL IDXBUILD.

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C idxcheck [ all ]

db-name

Specifies the database whose index you are checking.

all

Specifies that you want to check all your indexes.

If you do not specify all, the following menu appears:

            Index Check Utility 
            ---------------------------- 
            Select one of the following: 
            All - Check all the indexes 
            Some - Check only some of the indexes 
            Quit - Quit, do not check 
            Enter your selection: 

The following table describes the options:

Option
Action
All
Checks all the indexes.
Some
Prompts you for the indexes you want to check.
Quit
Quits without checking any indexes.

PROUTIL IDXCHECK performs the following operations for each index it checks:

IF PROUTIL IDXCHECK completes successfully, it ensures that all FIND, CAN-FIND, GET, FOR EACH, and PRESELECT statements that use those indexes work correctly. If errors result, the problem index might produce unexpected results with those statements.

NOTES


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095