Re: Upgrading on Solaris

Don Turrentine wrote: > > 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. I did many upgrades on Solaris and Informix OnLine but not SE. But your informix upgrade stays in 5.X. Hence, I believe you are right: it is an easy upgrade. Otherwise, you have to check out the Migration Guide. > 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. If I were you, I would wait until SE v5.07.UC1 is on your hand and read the release note. It happend to me several times that the release note addressed particular patches that tech support did not mention (or know). If I were you, I would back up OS (i.e., tar) and database before doing anything. I don't know the exact command for you to do backup, but I believe it is not necessary to dump tables through dbexport. Normally, I upgrade OS and then Informix. In this case, I believe you are right: Informix and then OS. If the informix upgrade succeeds, my guess is the OS upgrade will not cause MAJOR problem. But are you aware that there are things you need to do before upgrading 2.3 and 2.4 to 2.5? If you call Sun, they can fax the upgrade procedure to you (if it is applicable to your environment). Chao