Re: Re[2]: Migrating from 7.31 to 9.20

From: Ram.Mohan.Kompella@banctec.com > >Hello everybody > >I am in the database world for the last 5 years working on Informix ( as >well >as O and S ) > >Is any body sure out there that there are changes in storage data >structures >from 7.31 to 9.20 ? >dbexport and dbimport is okay for small databases. What if the Database >size is >a Terrabyte and above. I do not think Informix can afford recommend >'dbimport' >and 'dbexport' as a practical solution. Are you implying that my recommendations aren't up to snuff? :-) I think (and this is just a thought) that an in-place upgrade from 7.31 to 9.21 should be fairly painless. >Obnoxio The Clown wrote in message <8kc48c$jp6$1@news.xmission.com>... > > > >From: dins dins <dins_d@yahoo.com> > >> > >>So, which way would be better to ugrade database from > >>IDS 7.31 to IDS 9.20? > >> > >>1) To take backups from database, go to Quiescent mode > >>and install new version over older? > >> > >>OR: > >> > >>2) install 9.20, take dbexport from IDS 7.31 and > >>import it to 9.20? > > > >Call me old fashioned, but I prefer 2). Also, I don't think 1) will work, >I > >think you have to first revert to 7.30 then upgrade to 9.20. I could be > >wrong, though. Oh, and going Quiescent will probably not work anyway -- >you > >can't overwrite a file that's in use, IIRC. > >I guess I am old fashioned, too. I prefer exporting the data and then >importing it to the new version for all upgrades --- guess I find too many >cases where there is bad data (ugh!) or many tables with MULTIPLE extents >to >even try an in-place upgrade. > >David Weis >Louisville, KY USA >dweis@louisville-i-market.com >Voice: 502-637-7316 > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Don't be surprised if some of your "drop procedure" script shutdown your IDS9.2 instance after the upgrade. It is on Solaris2.6. Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8kdauo$c00$1@news.xmission.com... > > From: Ram.Mohan.Kompella@banctec.com > > > >Hello everybody > > > >I am in the database world for the last 5 years working on Informix ( as > >well > >as O and S ) > > > >Is any body sure out there that there are changes in storage data > >structures > >from 7.31 to 9.20 ? > >dbexport and dbimport is okay for small databases. What if the Database > >size is > >a Terrabyte and above. I do not think Informix can afford recommend > >'dbimport' > >and 'dbexport' as a practical solution. > > Are you implying that my recommendations aren't up to snuff? :-) > > I think (and this is just a thought) that an in-place upgrade from 7.31 to > 9.21 should be fairly painless. > > >Obnoxio The Clown wrote in message <8kc48c$jp6$1@news.xmission.com>... > > > > > >From: dins dins <dins_d@yahoo.com> > > >> > > >>So, which way would be better to ugrade database from > > >>IDS 7.31 to IDS 9.20? > > >> > > >>1) To take backups from database, go to Quiescent mode > > >>and install new version over older? > > >> > > >>OR: > > >> > > >>2) install 9.20, take dbexport from IDS 7.31 and > > >>import it to 9.20? > > > > > >Call me old fashioned, but I prefer 2). Also, I don't think 1) will work, > >I > > >think you have to first revert to 7.30 then upgrade to 9.20. I could be > > >wrong, though. Oh, and going Quiescent will probably not work anyway -- > >you > > >can't overwrite a file that's in use, IIRC. > > > >I guess I am old fashioned, too. I prefer exporting the data and then > >importing it to the new version for all upgrades --- guess I find too many > >cases where there is bad data (ugh!) or many tables with MULTIPLE extents > >to > >even try an in-place upgrade. > > > >David Weis > >Louisville, KY USA > >dweis@louisville-i-market.com > >Voice: 502-637-7316 > > > > > > > > > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >