SEO

#1 (**permalink**) 04-19-2008, 09:15 PM

Hi

I know Informix 5 SE is OLD but it is our platform for the forseeable
future. I have just massively increased the throughput of our SCO server
running this by way of adjucting the NBUF and NHBUF parameters in the
kernel. Are there any Informix specific parameters I can play with to see if
I can get even more from this aeging but solid and important database? Web
links or howto's would be very much appreciated. We have 512MB RAM (about
240 unused) on a P3 1Gig Proliant ML370. I have already flashed the firmware
on the RAID card giving around 30% a month ago more but the NBUF has just
doubled performance on top (and more in some cases where the same table is
hammered).

Thanks
Millsey

#2 (**permalink**) 04-19-2008, 09:15 PM

"Brian Mills" <brianmills@idontthinkyouunderstandspamprotection. co.uk> wrote
in message news:3MmdnS8AFYZ5swzdRVn-jg@nildram.net...
> Hi
>
> I know Informix 5 SE is OLD but it is our platform for the forseeable
> future. I have just massively increased the throughput of our SCO server
> running this by way of adjucting the NBUF and NHBUF parameters in the
> kernel. Are there any Informix specific parameters I can play with to see
if
> I can get even more from this aeging but solid and important database?

No, there aren't.
Could you look at moving to OnLine on Linux? There are some great deals to
be had for this product combination (which for some reason IBM are keeping
quiet about). We recently migrated a UK client from SE on SCO to OnLine on
Linux .....
--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby@ardenta.com

#3 (**permalink**) 04-19-2008, 09:16 PM

Brian Mills wrote:

> Hi
>
> I know Informix 5 SE is OLD but it is our platform for the forseeable
> future. I have just massively increased the throughput of our SCO server
> running this by way of adjucting the NBUF and NHBUF parameters in the
> kernel. Are there any Informix specific parameters I can play with to see
> if I can get even more from this aeging but solid and important database?
> Web links or howto's would be very much appreciated. We have 512MB RAM
> (about 240 unused) on a P3 1Gig Proliant ML370. I have already flashed the
> firmware on the RAID card giving around 30% a month ago more but the NBUF
> has just doubled performance on top (and more in some cases where the same
> table is hammered).

Am working much with SE for many year. Problem with perfomrance always fix
with index. Not any index, only right index.

--
Enor

#4 (**permalink**) 04-19-2008, 09:16 PM

There are things you could look at doing. What about UPDATE
STATISTICS? Is that being run regularly? Other respondents suggested
looking at indexes. I would also suggest looking at the location of
the tables. Are there any tables that have high access rates. You
could think about splitting these onto separate physical drives to
share the disk load. But the most important thing you need to
determine is what is holding things up. Are you disk, memory, or
processor bound? Once you know that you can think about moving
forward.

And where did you get the software from? Who developed the
application? I should talk to them for help in the first instance.

regards

Malcolm

"Brian Mills" <brianmills@idontthinkyouunderstandspamprotection. co.uk> wrote in message news:<3MmdnS8AFYZ5swzdRVn-jg@nildram.net>...
> Hi
>
> I know Informix 5 SE is OLD but it is our platform for the forseeable
> future. I have just massively increased the throughput of our SCO server
> running this by way of adjucting the NBUF and NHBUF parameters in the
> kernel. Are there any Informix specific parameters I can play with to see if
> I can get even more from this aeging but solid and important database? Web
> links or howto's would be very much appreciated. We have 512MB RAM (about
> 240 unused) on a P3 1Gig Proliant ML370. I have already flashed the firmware
> on the RAID card giving around 30% a month ago more but the NBUF has just
> doubled performance on top (and more in some cases where the same table is
> hammered).
>
> Thanks
> Millsey

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Informix 5 SE performance tuning?