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
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:
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
- When PROUTIL IDXCHECK finds any corruption, it displays error messages. If error messages appear, save the database and the output messages for analysis by Progress Software Corporation, then run PROUTIL IDXBUILD.
- IDXCHECK displays error and warning messages on the screen and logs them in the log file. It also displays and logs a success or failure indication, along with the number of errors and warnings issued.
- IDXCHECK might also display warning messages. Although these messages indicate that some condition is a problem, the index is still valid. Check the log file for details.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |