Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> IBM Informix
  2. Suggest New Category

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?

Question Posted / ekta agrawal


how would you check that a given index is consistent and has no corruption? If corruption occurred o..

Answer / 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

More IBM Informix Interview Questions

can I ask about perl, dbi and dbd informix? Other products?

1 Answers   IBM,

what is informix instance?

1 Answers   IBM,

what is chunk in informix?

1 Answers   IBM,

who conceived and designed the informix database management system?

1 Answers   IBM,

why is update statistics important to a database?

1 Answers   IBM,

what command would you use to move the physical log?

1 Answers   IBM,

what is the size of informix page?

1 Answers   IBM,

what are the uses of key value locking in informix?

1 Answers   IBM,

List down the features of informix 4gl.

1 Answers  

what is an extent in informix?

1 Answers   IBM,

What is the role of binary large object in informix?

1 Answers  

what is informix binary large object?

1 Answers   IBM,

For more IBM Informix Interview Questions Click Here
Categories