Re: Informix 4GL Version 1.10 bcheck fails

On Thu, 22 Oct 1998 17:15:37 GMT, oserj@netcom.com (Jim Oser) wrote: > > I am helping a client, who has > Informix-4GL Version 1.10 on an ATT 6386 WGS, which > is a 80386 at 25 MHz, running ATT Unix Rel 3.2 Version 2.3 > > bcheck -y > is passing on all files except chg_tra189.dat > which is giving > Error 226 > Error 4996 > Error 82851 > Error 4128 > It then says "Recreating index 2" and waits for 2 minutes > before aborting. > > Question: > 1) How can I get bcheck to pass? > 2) Customer only kept 3 days of backup and the system was not > working 3 days ago. > 3) Customer is moving to NT and does not want to stay on UNIX. > However, I was wondering if it would be possible to move > the existing database to SCO OpenServer 3 or 5. Can I simply > cpio the /usr/informix directory and the /usr/system/resort.dbs > and put it on the SCO box. > Will Informix realize it is on a different Intel box > with a different operating system? > > Jim Oser > oserj@netcom.com > > If I got this problems I unloaded the corrupted table to a new table that I later renamed to the old name; I think this could help. By the way there's no problem to migrate database files (*.idx and *.dat) from one system to another, we did it from Motorola-based AT&T to SCO Open Server (SE 5.x). The only thing to care for are the path-names in "systables", after all of the row "syslog" wich is an absolute pathname. Before any migration you have to eliminate field-names that are now reserved words!! Friendly regards Hartmut Babka BaSyS Babka Systems