Re: Upgrading on Solaris

Don Turrentine wrote: > > I am NOT an Informix DBA (for that matter no type of DBA). I am a Unix > that has been tasked with upgrading a system that is running Informix. > The system is running Solaris 2.3 and needs to go to 2.51. On the Informix > side it is running SQL v4.11 adn SE v5.01. We do have a maintenance > contract with Informix and tech support suggested that I go to SQL v4.16 UC1 > and SE v5.07 UC1. I am assuming this is an easier upgrade path for Informix > since there are definetely later versions out there that run under Sol 2.5. > Question is what is the proper path? - Do I upgrade Informix and then > do Solaris? I would expect this to be the case since the current version > of Informix we are using will not run under 2.51. - Or do I dump the tables > (somehow!) and import them back in after installing Solaris 2.51 and the > new Informix? Any help appreciated. > > Don > > -- Hi Don, I'm not a DBA or a sysadmin (!) but I think you need to look at an informix utility called dbexport. This creates all the sql statements necessary to recreate a databases, together with an ascii unload file containing the data for each table. Its sister command, dbimport, creates the database from the sql file and then loads it from the ascii data files. What you probably need to do is dbexport _each database_(to a filesystem/disk other than the one in the machine to be upgraded), install Solaris 2.5.1, install the new version of Informix (in the order Tools, Engine, Network components) and then dbimport each database. Cheers, Richard. All the usual disclaimers etc., etc.