Re: Question about upgrading IDS

On Wed, 30 Jul 2003 21:32:31 -0400, Madison Pruet wrote: Before AND after the upgrade. Art S. Kagel > Don't forget to make a backup..... ;-) > > > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:pan.2003.07.30.16.52.54.482955.15473@bloomberg.net... >> On Wed, 30 Jul 2003 11:36:03 -0400, Alan wrote: >> >> > Hi all, >> > >> > I am new in informix database administration. I am currently using >> > IDS 9.21.UC4 on Solaris7. However, it run very unstable, which >> > usually down with assertion fail, and we are planing to upgrade our >> > server to 9.4x. >> > >> > Does the upgrade process complicated? Do we need to re-create all >> > table spaces and tables after upgrade? Thank you. >> >> No. Just install the 9.4 into a new directory, shutdown the 9.21 >> engine, change INFORMIXDIR to point to the new directory, configure the >> sqlhosts > and >> ONCONFIG files in the new $INFORMIXDIR/etc, restart the 9.4 engine. >> When the engine realized the reserved pages are for pre-9.4 it will >> auto convert all disk structures. That mostly it. There are a couple >> of manual conversions you will have to make. See the 9.4 release notes >> for details. Nothing big like recreating everything. >> >> Art S. Kagel