Re: Rebuilding Indexes

Path: emory!europa.asd.contel.com!uunet!ispd-newsserver!kodak!static!amiano From: amiano@static.Kodak.Com (Mitch Amiano) Newsgroups: comp.databases.informix Message-ID: <1991Nov11.214433.25031@kodak.kodak.com> Date: 11 Nov 91 21:44:33 GMT References: <1991Nov11.193952.16934@nynexst.com> Sender: amiano@static (Mitch Amiano) Organization: Eastman Kodak Co., Rochester, NY In article <1991Nov11.193952.16934@nynexst.com>, matrix@nynnexst.com (Howard Greenblatt) writes: |> [...stuff deleted...] |> I'm trying to help a friend rebuild his database after |> a hard disk crash. [...stuff deleted...] |> 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 can't comment on Informix 3.3 (never used it :-> ), but I had a similar problem a few times recently with the SE engine, and a database which had been trashed. It seemed that Informix' systables somehow went out of sync with the actual C-ISAM files. The systables row contains a path name to the discrete file used for data along with the table name used by/for sql access. So we had an ORDER table, which in the file system was order_156.dat (or close, I don't remember), but Informix thought it should have been order_154.dat. The immediate fix was to login as the dba, create a default systables form, and fix the path name entries manually. Then rebuild the indexes. This worked without a hitch. |> |> Thanks! |> |> Howard Hope it helps. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Mitch C. Amiano, Software Contractor Rochester, NY 716-226-2024 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --