Oninit cdi / Archive
Talk to an expert →

Question about upgrading IDS

Posted in 2003

Topics: Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Alan — — source: Usenet: comp.databases.informix

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.

↪ replying to Alan
Art S. Kagel — — source: Usenet: comp.databases.informix

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

↪ replying to Art S. Kagel
Madison Pruet — — source: Usenet: comp.databases.informix

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

Related threads

Glossary