Hi,
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?

I am considering implementing it throughout an ERP (SAP 3.1i_com)
landscape. KAIO has been active on a Development system (40 GB on 76
chunks using 24 raw volumes) for over a year without any issues. But this
system has very low activity compared with the Production system (725 GB on
589 chunks using 439 raw volumes).

The GB mentioned is in assigned table space (not dbspace). The landscape
is OLTP 99% of the time. Production system averages 2000 raw I/O's per
second during the day, and up to 3000 raw I/O's per second at night. The
system has no bottlenecks with CPU, Memory, or Disk. There are 200
NUMAIOVPS configured. In the last 12 days of the system, the overall
workload of AIO pids (from unix ps -elf) is as follows:

first 25 handles 50% of the aio requests
first 50 handles 77% of the aio requests
first 75 handles 90% of the aio requests
first 100 handles 95% of the aio requests
last 100 are actually being used, but only for 5% <-- law of
diminishing returns

Beside the fact that each AIO requires an open file for each of the 439 raw
volumes (links to them), does anyone know if there is a performance penalty
for having so many open files on the system (200*439)?

If everything seems okay to move to KAIO, is there an issue with setting
IFMX_HPKAIO_NUM_REQ to the max value of 5000?

From the Release note:
Due to an OS limitation for Kernel Asynchronous I/O (KAIO) on HP, at
present all Informix shared memory segments are locked in main memory.
There is no mechanism to free these segments dynamically. All Informix
shared memory segments are unconditionally locked in. Since Informix
sometimes creates shared memory segments dynamically, KAIO may cause
some memory pressure in rare cases.

--> This shouldn't be an issue because I lock all segments and have plenty
of memory available.

PRODUCT NAME : ONLINE
BUG NO. DESCRIPTION
----------------------------------------------------------------------
101363 KAIO THREADS RUN ON AIO VPS

--> Is this for versions of IDS? Anyone have any info on this? The
Product Defect Query only shows corrections for Solaris, not HP-UX.

Thanks in advance,
Tim


sending to informix-list

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.

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

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.

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?
>

Plus, further to my earlier post, with KAIO you don't have the pain in
the a** of managing all the AIO VPs.

Malc_p

Malc P wrote:

> 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.

If I could dish out awards for this sort of thinking, I would. I'm proud to
know you!

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"Malc P" <malc_p@btinternet.com> wrote in message
news:8c28402a.0402070231.6006d74b@posting.google.c om...
> 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).

I agree. I think the apprehension about kaio and HP-UX stems from some
combinations - IDS 9.21 and HP-UX 10.20 is one that comes to mind - where
kaio was suspected to cause some assert failures. UK Tech Support Wizard
Marco Greco is an expert on this: perhapos he'll comment ....

http://www.smooth1.demon.co.uk/ifaq06.htm#6.20

Look for the bit starting...

Here is the real story behind Informix/HP KAIO over the years...

"Malc P" <malc_p@btinternet.com> wrote in message
news:8c28402a.0402070238.38a7a040@posting.google.c om...
> 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?
> >
>
> Plus, further to my earlier post, with KAIO you don't have the pain in
> the a** of managing all the AIO VPs.
>
> Malc_p