Re: Upgrade Question -- 5.07 to 7.10

Billy Wheeler wrote: > > > > > I'm installing 7.10 UD1 on my test system this weekend, and am currently > > running 5.07.UC1 (SCO 3.2.2). > > > > My questions are as follows: > > > > If I install 7.1 to a different directory (i.e., informix7 and maintain > > 5.01 in informix5), can I just modify the onconfig file to 'match' the > > 5.01 tbconfig file and initiate an instance of 7.1 online in place of > > 5.01? > > You *should* be able to do this. I, however, wouldn't. > > > Or do I have to re-initialize the root dbspace, and subsequently restore > > from backup? > > I would advise that you dbexport, reinitialize and dbimport. > > > Also, I'm running some rather archaic tools (release 4.x of isql, > > [r/i]4gl). Any caveats I should be worried about (like recompiling, > > etc.)? > > Yep. You'll have to recompile everything to 4gl version 6.x The comms between > the tools and the front end have changed. Your alternative is to use the > relay module, but there will be a *major* performance impact. > > I don't know what the latest status of this issue is, but you also have to > remember that there are some subtle differences between 4.1x 4gl and 6.x 4gl. > Examine the release notes *very carefully*. > > Good luck. > > -- > Ciao, > > Billy > > +------------------------------------------------------------------------------+ > | I used to be indecisive, but now I'm not so sure... | > +------------------------------------------------------------------------------+ I would ALSO do tbtape -s and a tar or cpio of the informix software, just in case you have to go back to 5.x. Doing a dbimport takes longer than restoring an archive. I did the upgrade more than a year ago so you might want to check with informix with what you're about to read. You can always do a cold restore of a 5.x onto 7.10 and then start the 7.x engine. I did this once or twice because the upgrade wasn't going well. Informix told me later that their upgrade utility had a problem with the indexes and that we should drop and recreate them and our problems would go away. From what I remember they did.