Re: Rebuilding Indexes

Posted in 1991

Walt Hultgren {rmy} — Tue, 12 Nov 91 09:00:23 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!samsung!uakari.primate.wisc.edu!ames!agate!spool.mu.edu!uunet!ftpbox!mothost!white!glas!shubrick From: shubrick@glas.rtsg.mot.com (Mark Shubrick) Newsgroups: comp.databases.informix Message-ID: <1991Nov12.103707.846@glas.rtsg.mot.com> Date: 12 Nov 91 10:37:07 GMT References: <1991Nov11.193952.16934@nynexst.com> Organization: Motorola Ireland Ltd., Cork, Ireland. In comp.databases.informix you write: >... > So here's the question: Can I save the data? >I tried rebuilding the tables, copying the old data files >over the new ones and then running bcheck, but it does not >recognize the new data. Any ideas or suggestions??? >... I not real sure where the problem is (disclaimer)? Maybe try copying new idx files into the database instead of the dat files. This initially would mean to create a dummy database, x, copy its idx files into your database and run bcheck (bcheck -y sys*.idx). That hopefully would re-establish the system and if so a simular approach may be taken for the actual tables. let us know how you get along. -- Mark Shubrick | UUCP: ...uunet!motcid!glas!shubrick Motorola Ireland Ltd. | Internet: shubrick@glas.rtsg.mot.com Blackrock, Cork, Eire. | Ph: +353-21-357101. Fax: +353-21-357635