Question about upgrading IDS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 30 Jul 2003 16:36 GMT

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.

Reply to this Message

Art S. Kagel - 30 Jul 2003 21:53 GMT

> Hi all,
>
[quoted text clipped - 4 lines]
> 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

Reply to this Message

Madison Pruet - 31 Jul 2003 02:32 GMT

Don't forget to make a backup..... ;-)

> > Hi all,
> >
[quoted text clipped - 14 lines]
>
> Art S. Kagel

Reply to this Message

Art S. Kagel - 31 Jul 2003 20:16 GMT

Before AND after the upgrade.

Art S. Kagel

> Don't forget to make a backup..... ;-)
>
[quoted text clipped - 19 lines]
>>
>> Art S. Kagel

Reply to this Message