Progress
Database Administration
Guide and Reference


PROUTIL IDXFIX Qualifier

Checks the Progress database records and indexes to determine whether an index is corrupt or a record has a missing or incorrect index. You can specify whether to scan the database, the indexes, or both. You can run IDXFIX online or offline.

NOTE: The _UserStatus virtual system table displays the utility’s progress. For more information, see Maintaining Database Structure."

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -silent -C idxfix

db-name

Specifies the database whose index you are checking.

silent

Indicates that repetitive messages are not sent to the screen or the log file.

The Index Fix utility displays the following menu:

                   Index Fix Utility 
            Select one of the following: 
            1. Scan records for missing index entries. 
            2. Scan indexes for invalid index entries. 
            3. Both 1 and 2 above. 
            4. Cross-reference check of multiple indexes for a table. 
            5. Build indexes from existing indexes. 
            6. Delete one record and its index entries. 
            7. Quit 
            Enter your selection: 

The following table describes the options:

Option
Action
1
Scans the database records for missing or incorrect indexes.
2
Scans the index for corrupt index entries. You can specify whether to scan all indexes or a specific set of indexes.
3
Checks the index entries, then checks the database entries.
4
Prompts you for the table and indexes for which you want to run a cross-reference check.
Allows you to choose two or more indexes from one table. It first scans them for invalid keys, then scans them for invalid records.
5
Prompts you to specify the table and the index that you want to use as the source from which to build the index.
6
Prompts you to specify the recid of the record you want to delete.
Deletes one record and all its indexes from the database. Use this option when a record has damaged indexes.
7
Ends the PROUTIL Index Fix utility.

NOTES


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