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
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:
The following table describes the options:
NOTES
- PROUTIL IDXFIX performs the following operations for each index it checks:
- IDXFIX displays error 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. IDXFIX 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.
- Index Fix does not provide a comparison of the index scan and the database scan when you run them online because the database can change during operation.
- Index Fix is designed to wait if a record is in the process of being updated, thus ensuring that it does not incorrectly change a user action in process. However, because changes can occur during the scans, the reported data might not exactly match the database at completion. Index Fix displays this warning when you run it online.
- To run Index Fix online, it must be run as a self-service session.
- Index Fix does not delete or disable indexes, but when you run a full database scan with fix offline and it is successful, it enables a disabled index if no errors are found.
- Enabling indexes online is not advisable because it is not possible to detect changes that are being made to indexes while the process is running.
- While IDXFIX can ensure that an index is complete and correct, it cannot make any improvement to the index’s utilization level.
- See "Maintaining Database Structure," for a description of how to monitor the progress of this utility using the _UserStatus Virtual System Table (VST).
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |