Re: WHY index can corrupted???

I neglected to add 4) using non-logging databases as a reason that the index might become corrupt. M.P. "Madison Pruet" <mpruet@comcast.net> wrote in message news:13u_a.136832$Ho3.16682@sccrnsc03... > There is absolutely no reason for index corruption. If the index should > become corrupt, then it means that a bug has been encountered. Please open > a case with tech support to try to discover the root cause of the > corruption. > > The only exception to this would be the case where either something outside > of the engine induced the corruption. This might include > > 1) the hardware did not do a physical IO that the os(software) thought had > been done > 2) the user did somthing wrong such as having two instances using the same > chunk > 3) the customer ran into some kind of problem and the logical logs were > patched so that the normal recovery could not successfully complete > > > M.Pruet > > "miyaki" <lcib@yahoo.com> wrote in message > news:bhc6qc$vu9$1@terabinaries.xmission.com... > > > > 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 > >