We did an upgrade similar to this a while ago. I don't recall the exact
versions but we are on Tools 8.48 now and the move from Informix 7.31 to
9.4 did improve performance noticeably.

HTH,
-D


________________________________

From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of DL Redden
Sent: Thursday, August 09, 2007 6:43 PM
To: Carsten Haese; informix-list@iiug.org
Subject: Re: Why should I upgrade my 7.31 instance to 9.4 or
10.0


I love your thought process. Will consider.



----- Original Message ----
From: Carsten Haese
To: informix-list@iiug.org
Sent: Thursday, August 9, 2007 4:17:03 PM
Subject: Re: Why should I upgrade my 7.31 instance to 9.4 or
10.0


On Thu, 2007-08-09 at 14:00 -0700, DL Redden wrote:
> We have a PeopleSoft 7.52 installation still running on IDS
7.31.UC4.
> I want to upgrade/migrate the database
> to a newer version of Informix, probably 9.40.FC7 or 10.0.FC6.
The
> version will be dictated by the PS 8.48 or 8.49 tools that we
install.
> I'm looking for reasons that would help me sell this idea to
my upper
> management.
>
> I can think of a few reasons that make me want to make to
move, such
> as:
>
> longer object names (The 18 character limit is a thorn in my
side),
> better buffer management (I think, someone please confirm
this),
> IDS 7.31 is reportedly EOS in April of 2009
>
> Quite honestly I'm having a hard time coming up with a good
list of
> reasons since we've been running in this configuration for 7
or more
> years and it just runs. You have to love Informix for this
trate but
> right now I just wish it'd break so that I'd have a good
reason to get
> it upgraded.
>
> Can anyone help me out in making a case?

The upgrade should improve performance. If users aren't
complaining
about performance yet, nuke a couple of indexes, and tell the
users the
application has outgrown the database server and it needs to be
upgraded ;-)

--
Carsten Haese
http://informixdb.sourceforge.net


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list





_____________________________________________________________________________________

The information contained in this email may be confidential and/or legallyprivileged. It has been sent for the sole use of the intendedrecipient(s). If the reader of this message is not an intended recipient,you are hereby notified that any unauthorized review, use, disclosure,dissemination, distribution, or copying of this communication, or any ofits contents, is strictly prohibited. If you have received thiscommunication in error, please contact the sender by reply email anddestroy all copies of the original message. To contact our emailadministrator directly, send to postmaster@dlapiper.com

Thank you.
_____________________________________________________________________________________