Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROUTIL IDXCHECK qualifier

> Checks database indexes to determine whether an index is corrupt, and if it is, diagnoses the problem.

> #### Syntax

> proutil`db-name` -C idxcheck [ all |table [`owner-name.`]`table-name` |
>          area area-name | schema schema-owner]

> #### Parameters

> ``db-name``

> Specifies the database whose index you are checking.

> `all`

> Specifies that you want to check all your indexes.

> `table [`owner-name.`]`table-name``

> Specifies that you want to check the indexes defined for the named table.

> `area `area-name``

> Specifies that you want to check all the indexes defined in the named area.

> `schema `schema-owner``

> Specifies that you want to check all the indexes owned by the named `schema-owner`.

> If you do not specify `all`, `table`, `area`, or `schema`, the following menu appears:

>           Index Check Utility
>           ===================
>           Select one of the following:
>           All           (a/A) - Check all the indexes
>           Some          (s/S) - Check only some of the indexes
>           By Area       (r/R) - Check indexes in selected areas
>           By Schema     (c/C) - Check indexes by schema owners
>           By Table      (t/T) - Check indexes in selected tables
>           Quit     (q/Q) - Quit, do not Check
>           Enter your selection:

> Table 20–3 describes the options.

> Table 20–3: PROUTIL IDXCHECK options
> Option | Action
> --- | ---
> All | Checks all the indexes.
> By Area | Prompts you for the area containing the indexes you want to check.
> By Schema | Prompts you for the schema owner of the indexes you want to check.
> By Table | Prompts you for the table containing the indexes you want to check.
> Some | Prompts you for the indexes you want to check.
> Quit | Quits without checking any indexes.

> PROUTIL IDXCHECK lets you know whether you have to perform an index rebuild before actually running PROUTIL IDXBUILD. IDXCHECK performs the following operations for each index it checks:

> - Reads the contents of the index and the contents of the file, verifies that all the values in the records are indexed, and verifies that each value in the index is in the associated record.

> - Performs various checks on the data structures in the index to verify that there is no corruption.

> 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 Technical Support, back up your database, and 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095