Question about upgrading IDS

[Alan]

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.

[Art S. Kagel]

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

[Madison Pruet]

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@bloomber g.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

[Art S. Kagel]

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@bloomber g.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