Re: Index Corruption - Online V5.02.UC1

In article I04@txnews.amd.com, truong@aunext4.amd.com (Ben Van Truong) writes: > We are running Informix Online V5.02.Uc1 on HP-UX. We recently faced > an Index Corruption problem and after tbchecking we dropped and recreated > the Index and things are back to normal. > > The activity on the table was normal. The table sees only insert and > query activity. (No updates/deletes/index modifications). The table > had about 78000 rows and the chunks reside on LVM disks. The index > is made up of two fields and uses a descending clause. > > What I would like to know is a) what are the situations under which such > a corruption occurs and b) what ( if any) are the steps that can be > taken to eliminate/minimize such occurences. > > Thanks for all responses > Raj Raj, We have experienced a similar situation. We haven't been able to define exactly what is happening when the corruption occurs or what is causing the corruption. However, Informix has said that our problem should be fixed when we upgrade to 5.03. We have this planned and will keep our fingers crossed that it will take care of our problem. You might want to talk with tech support about upgrading to 5.03. If you do talk with them you might want to ask them to refrence case # 302295. Good luck! -Debbie Shelton DBA McCaw Cellular Communications, Inc. debbie.shelton@mccaw.com