Re: Upgrading Informix from Online engine to Dynamic Server

I would agree with John, that with some courses (around the time your going to upgrade) you can get it done. Read the migration guide for differences in sizing considerations, etc. Also, read the posts in this group (use DejaNews) regarding 7.X performance issues / fixes. You can get a lot of it taken care of using common sense, and good monitoring of the environment! BTW: we've done our upgrades slightly different than John -- we've tended to do "in place" upgrades. Either way will work... Eric P. Melillo Senior DBA Associated Grocers Seattle, WA carlson1@bellsouth.net on 01/20/98 01:39:32 PM Please respond to carlson1@bellsouth.net To: informix-list@rmy.emory.edu cc: (bcc: Eric Melillo/AGInc) Subject: Re: Upgrading Informix from Online engine to Dynamic Server Jane Vohden wrote: > > I have been talking with Informix about upgrading our site from the = > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost = > for the upgrade because we are on maintenance but they quoted us a = > consulting fee of $2000 per day plus expenses and said that most of = > their customers were using an Informix consultant to do the upgrade and = > then tune. I know some of you have been through that conversion. Did = > you use an Informix consultant? For how many days? What about a = > Bi-Tech consultant? How smooth was the transition? Were there any = > "gotchas" that we should be on the look-out for? Any info on this would = > be appreciated. Thanks. > We went from 5.0x to 7.12 with few problems. We never used a consultant. The upgrade consisted of dbexport, install 7.1x, bring engine up, dbimport. I was able to make a good guess of dbspace / table layouts based on our current system. The system required a bit of tuning, as 7.x is quite different from 5.x, but I went to various courses as well. Between them and OJT, we handled the situation quite nicely. John Carlson Informix DBA WH Smith, Inc.