Informix SE

Posted in 1999

Michael Muir-Browne — Tue, 16 Feb 1999 18:47:29 -0000 — source: Informix-list mailing list archive (1991-1998)

Hi, I have been given the task of upgrading an Informix 5 database to Informix 7. Has anyone here had any experience of this and are there any problems associated with it? cheers Michael

↪ replying to Michael Muir-Browne

Surfer! — Tue, 16 Feb 1999 22:23:01 +0000 — source: Informix-list mailing list archive (1991-1998)

I have upgraded a number of databases and in general there are no problems. However: i) The rock-sure method is to dbexport & dbimport as then all tables including system catalogues are rebuilt. ii) If you can't do the above, bcheck *all* tables including system catalogues - you have to be informix to do these. Once OK take a backup! Then simply open the database with Informix 7 & run update Statistics. iii) If ii) above fails restore the database and (last ditch before resorting to i) above) run 'bcheck -s' on the system catalogues (sys*.dat) which will rebuild the '.idx' files and hopefully that will cure the situation. However.... Presumably you also have some programs possibly written in 4GL. Programs, forms & reports will all need recompiling and you will probably find some new compilation errors as the compiler is 'fussier' in the new version. In article <V2jy2.9$uE1.125@stones>, Michael Muir-Browne <Michael@truecs.force9.co.uk> writes >Hi, > >I have been given the task of upgrading an Informix 5 database to Informix >7. Has anyone here had any experience of this and are there any problems >associated with it? > > >cheers > >Michael > > Surfer! URL: http://www.nevis-vieww.demon.co.uk Email: surfer@nevis-vieww.demon.co.uk Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

↪ replying to Surfer!

Michael Muir-Browne — Thu, 18 Feb 1999 10:14:54 -0000 — source: Informix-list mailing list archive (1991-1998)

Thanks for the information. best regards Michael