how to recover from lost index pointers

[MichelleButler]

I had a failure on my unix server and this has caused some corrupted data of the database, one in paticular a table called mscol. I have recover the dat files and the idx files from a recent backup but the data pointer seems to be missing and does not allow me to retrieve the data correctly from the database. Please could anybody help me, I need to recover from a database index pointer problems. I hope you understand.

thanks

 

[olded]

Michelle:

If I were you, I'd drop the index on your table and recreate it. That might fix your problem.

Regards,

Ed

 

[gheist]

or

update statistics high for table table_name;

or
oncheck -cI databasename:table_name

hey - check online.log for disk problems - (errno 5)
it is not fixable in software then

 

[olded]

Michelle:

I gathered from your post you are using Standard Engine. Regarding gheist's post, if you are running SE prior to version 7.x, the command will not be oncheck - it will be tbcheck.

It's been years since I've run SE, but I never had any luck trying to fix an index with informix tools; I always dropped and recreated the offending index.

If you need help doing that, I'd be glad to answer any other questions.

Ed

 

[MichelleButler]

Many thanks for all your solutions, I have found that bcheck has help me regenerate all the indexes. Once again.

Many thanks

Michelel