KAIO statistics

I am built a small test database server to test KAIO. What does it mean when one KAIO is doing nothing and one KAIO has done everything? Here is onstat -d and onstat -g ioq Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 14:46:41 -- 24576 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 1085413c 1 1 1 1 N informix rootdbs 108548dc 2 1 2 1 N informix phydbs 10854998 3 1 3 1 N informix logdbs 10854a54 4 2001 4 1 N T informix tempdbs 10854b10 5 1 5 2 N informix datadbs1 5 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 108541f8 1 1 0 50000 4329 PO- /DBSCHUNKS/ronline01 10854490 2 2 50000 50000 2 PO- /DBSCHUNKS/ronline01 1085456c 3 3 100000 75000 0 PO- /DBSCHUNKS/ronline01 10854648 4 4 175000 50000 49907 PO- /DBSCHUNKS/ronline01 10854724 5 5 225000 274999 160389 PO- /DBSCHUNKS/ronline01 10854800 6 5 0 250000 236242 PO- /DBSCHUNKS/ronline02 6 active, 2047 maximum AIO I/O queues: q name/id len maxlen totalops dskread dskwrite dskcopy kio 0 0 0 0 0 0 0 kio 1 0 32 176116 175777 339 0 adt 0 0 0 0 0 0 0 msc 0 0 1 143 0 0 0 aio 0 0 5 194 82 2 0 pio 0 0 0 0 0 0 0 lio 0 0 0 0 0 0 0 gfd 3 0 0 0 0 0 0 gfd 4 0 0 0 0 0 0 gfd 5 0 0 0 0 0 0 gfd 6 0 0 0 0 0 0 gfd 7 0 0 0 0 0 0 gfd 8 0 0 0 0 0 0 Can anyone tell me about changes to kernel parameters needed for KAIO on HP and SCO? Does it increase with extra users? How di I know that I need more. thankyou Sent via Deja.com http://www.deja.com/

In article <95qae6$bbh$1@nnrp1.deja.com>, Dr. Pablo <dr_pablo@my- deja.com> writes >I am built a small test database server to test KAIO. >What does it mean when one KAIO is doing nothing and one KAIO has done >everything? > >Here is onstat -d and onstat -g ioq > > >AIO I/O queues: >q name/id len maxlen totalops dskread dskwrite dskcopy > kio 0 0 0 0 0 0 0 Known bug, run onstat -g ath and you should find that the KAIO thread is running on an AIO vp (should be CPU VP!). It never seems to get activated so it has no effect. >Can anyone tell me about changes to kernel parameters needed for KAIO >on HP and SCO? Does it increase with extra users? How di I know that I >need more. > >thankyou > > >Sent via Deja.com >http://www.deja.com/ -- David Williams

In article <muY4pVAeoVg6EwGU@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > Known bug, run onstat -g ath and you should find that the > KAIO thread is running on an AIO vp (should be CPU VP!). > > It never seems to get activated so it has no effect. > Thankyou. I was surprised to see the unused kio on the statistics. Can you tell me if there are kernel parameters to set un HP, and how to know the best setting? On the SCO I got system messages saying out of AIO buffers so I changed these by multiply by 10. I don't know if that is still enough, but there are no messages now ofr the testing database. Can you advise? NAIOBUF 2000 NAIOLOCKTBL 200 NAIOPROC 20 NAIOREQ 2000 NAIOREQPP 2000 NAIOHBUF 25 I can not find any kernel parameters to change for HP. Is that OK? All I can find in release notes is An environment variable IFMX_HPKAIO_NUM_REQ is provided to specify the number of simultaneous KAIO requests that are processed by the server at one time. The value can be set in the range of 10 to 5000, the default being 1000. If the error "KAIO: out of OS resources, errno = %d, pid = %d" occurs, consider increasing the value of IFMX_HPKAIO_NUM_REQ. IFMX_HPKAIO_NUM_REQ=2300; export IFMX_HPKAIO_NUM_REQ Does that make HP allocate as it needs? Is it true the need for this KIAO requests will depend on activity only? Thank you again for helping. Sent via Deja.com http://www.deja.com/

Have you set NUMAIOVPS=1 which is what's recommended for KAIO on raw chunks only. Yours -- Earle A Long (Senior DBA) SinglePoint Limited "Dr. Pablo" <dr_pablo@my-deja.com> wrote in message news:95soiv$fmu$1@nnrp1.deja.com... > In article <muY4pVAeoVg6EwGU@smooth1.demon.co.uk>, > David Williams <djw@smooth1.demon.co.uk> wrote: > > > Known bug, run onstat -g ath and you should find that the > > KAIO thread is running on an AIO vp (should be CPU VP!). > > > > It never seems to get activated so it has no effect. > > > Thankyou. I was surprised to see the unused kio on the statistics. > > Can you tell me if there are kernel parameters to set un HP, and how to > know the best setting? On the SCO I got system messages saying out of > AIO buffers so I changed these by multiply by 10. I don't know if that > is still enough, but there are no messages now ofr the testing > database. Can you advise? > > NAIOBUF 2000 > NAIOLOCKTBL 200 > NAIOPROC 20 > NAIOREQ 2000 > NAIOREQPP 2000 > NAIOHBUF 25 > > I can not find any kernel parameters to change for HP. Is that OK? All > I can find in release notes is > > An environment variable IFMX_HPKAIO_NUM_REQ is provided to specify the > number of simultaneous KAIO requests that are processed by the server > at one time. The value can be set in the range of 10 to 5000, the > default being 1000. If the error > > "KAIO: out of OS resources, errno = %d, pid = %d" occurs, consider > increasing the value of IFMX_HPKAIO_NUM_REQ. > > IFMX_HPKAIO_NUM_REQ=2300; export IFMX_HPKAIO_NUM_REQ > > Does that make HP allocate as it needs? > > Is it true the need for this KIAO requests will depend on activity only? > > Thank you again for helping. > > > Sent via Deja.com > http://www.deja.com/ >