WHY index can corrupted???

Posted in 2003

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues

miyaki — Tue, 12 Aug 2003 19:01:38 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to miyaki

Fernando Nunes — Wed, 13 Aug 2003 12:22:23 +0100 — source: Usenet: comp.databases.informix

miyaki wrote: > Anybody knows the reason that may cause the index > corruption??? BUG, hardware problem, or maybe a BTREE cleaner abort due to some system failure (which will probably a BUG anyway). Regards.

↪ replying to miyaki

Madison Pruet — Wed, 13 Aug 2003 16:54:21 GMT — source: Usenet: comp.databases.informix

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

Glossary

dbexport / dbimport