Re: WHY index can corrupted???

Usually, in my experience, I've seen index corruptions due to a scenario where multiple sessions are accessing the same table/index and some of them are doing so in dirty read isolation causing the corruption ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi miyaki <lcib@yahoo.com> To: ids@iiug.org, informix-list@iiug.org Sent by: cc: owner-informix-li Subject: WHY index can corrupted??? st@iiug.org 08/12/2003 07:01 PM Hi all, OS : Sun Solaris 2.7 IDS : 7.31.UD5 Recently my database engine was crashed due to the index corruption. The engine was back up after repairing the index by using the oncheck command. I'm wondering why the index can be corrupted? In fact, I just performed the database re-org by using the dbexport-import at 3 months ago. Anybody knows the reason that may cause the index corruption??? Appreciate for the comments. TIA, MIyaki __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com sending to informix-list sending to informix-list