RE: is it ok to use KAIO on HP-UX
It do not mean to say that this particular old bug still exists.
On SUN, KAIO is switched on by default.
That means, that entire internal QA testing is made with KAIO.
On HP, KAIO is 'off' by default.
That means, that EVERYTHING was NOT tested properly by QA with KAIO.
That is, You need to make comprehensive testing of the
entire system, including backup, restore, replication, onpload
(whatever You use in Your system) yourself.
Please, note also, that only specific applications might benefit
from KAIO. Overall database performance might not be improved.
Moreover, transactional users can hardly notice any improvement
in response time. Only operations that create permanent load on
the database server (batch processing, DSS queries) might benefit by
stealing disk/CPU resources from transactional applications.
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Obnoxio The Clown [mailto:obnoxio@hotmail.com]
> Sent: Monday, February 09, 2004 10:38 AM
> To: informix-list@iiug.org
> Subject: RE: is it ok to use KAIO on HP-UX
>
> Alexey Sonkin wrote:
>
> >
> > 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?
>
> AFAIK, both 10.20 and 7.30 are so old they're unsupported. Why do you
> think
> that issue still exists?
>
> > -----Original Message-----
> > From: malc_p@btinternet.com [mailto:malc_p@btinternet.com]
> >
> > 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.
>
> --
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche
sending to informix-list