Interested to Buy Any Domain ? << Click Here >> for more details...
how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?
- 1 Answers
- 112 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / Rekha Ranjani
To verify the consistency of an index in Informix, you can use the 'dbcheck' utility. This tool checks all tables and their associated indexes for inconsistencies or corruptions. If corruption is detected, the process to recover a corrupt database includes restoring from the latest backup, repairing any damaged objects using tools like 'repairdb', and rebuilding affected indexes using 'rebuildindex'. Preventive measures include regular backups, checkpoint optimization, and monitoring system logs for signs of errors or failures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
