Re: Upgrading Informix from Online engine to Dynamic Server

Eric_Melillo@agsea.com wrote: > > 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. The only reason we did the import/export was to attempt to organize the tables. The original table layouts were a mess. Guess who got to clean it up?? I guess it's job security John Carlson Informix DBA WH Smith, Inc.