bcheck, SE and OnLine

Posted in 1993

Paul Smith — Wed, 5 May 1993 11:35:03 +0000 — source: Informix-list mailing list archive (1991-1998)

I have a system in which most of the data is stored in 2 files, one containing master copy of serial numbers, the other linking pairs of serial numbers together, as well as storing other info about the matched pair. This is running on an Informix-SE engine (2.10.03K) on a Motorola 68040-based platform under AT&T Unix System 5.3 Currently there are some 1.5 million rows in the master file and some 350000 rows in the pairs file. I have a number of questions which netlanders may be able to help with 1) Periodically, bcheck reports corruption of the index file. Any ideas what could cause this ? 2) Repairing the indexes takes some 8 hours, not funny on a production system. Any tips for speeding it up ? 3) Given the amount of data, are we really asking too much of SE and should we be looking to upgrade to an Informix-Turbo or even an OnLine system ? Answers on a postcard please. -- Regards, Paul -------------------------------------------------------------------------------- Paul Smith, Tel. : +44 (0)31 479 1233 Motorola I.C.S.G., Fax. : +44 (0)31 479 1447 Easter Inch, Post : w10070 Bathgate, email: pauls@easter.euro.csg.gss.mot.com West Lothian, Mobile: +44 (0)836 522062 EH48 2EH Pager : +44 (0)523 623016