RE: is it ok to use KAIO on HP-UX
I agree that performance should be slightly better with KAIO.
Unfortunately, I had VERY BAD reliability issue with IDS 7.30
on HPUX 10.20 related to KAIO: I couldn't restore Informix
issue with 'ontape' when KAIO was 'on'. Soon after starting 'ontape -r', one
CPUVP
started consuming 100% resources of one CPU infinitely.
I've repeated that experiment several times.
No need to say, that, by changing a single parameter (switching off KAIO)
I was able to restore without any problem
Is 30% performance gain on certain tasks worth such loss
in reliability?
Best regards,
Alexey Sonkin
-----Original Message-----
From: malc_p@btinternet.com [mailto:malc_p@btinternet.com]
Sent: Saturday, February 07, 2004 5:31 AM
To: informix-list@iiug.org
Subject: Re: is it ok to use KAIO on HP-UX
Obnoxio The Clown <obnoxio@hotmail.com> wrote in message
news:<c00k2u$11qsee$1@ID-64669.news.uni-berlin.de>...
> timothy.a.brown@marconi.com wrote:
>
> > I need info on the Pro's and Con's of running KAIO on HPUX 11.0 using
> > Informix 7.31.FD2. Are there any www links on Performance tests?
Sizing
> > issues?
>
> JFDI.
Yup, what he said.
We're now on HP-UX 11i with IDS9.30 but have had HP10.20 for nnn years
on IDS7.31
and very early on found KAIO improved throughput on the batch work by
a good 30%
(this is largely OLTP with a smattering of warehousing due to
retention of old never-used data).
Malc_P
PS "JFDI": I worked, many years ago, in a defence-industry electronics
company where most projects were strictly controlled and even the
smallest change had to go through the usual (typically British)
anally-retentive gamut of meetings, justifications, procedures and the
rest of it. I managed (eventually) to bring attention to the bleeding
obvious fact that somethings can be done bypassing this route, and the
means to do this was eventually rubber-stamped into the procedures
with the name "Jobs For Direct Implementation". Manglement neve
twigged. So a small arm of General Dynamics in the UK now has "JFDI"
projects enshrined in their BS9000-approved documentation.
sending to informix-list
sending to informix-list