ids11.5 enable AIO on AIX 6.1 - comp.databases.informix

os: AIX 6.1 informix: ids11.5.fc6 Before AIX 5.x , To start ids ,It need to run 'mkdev -l aio0'. But under AIX 6.1, there are two question bothering me. 1. can not enable AIO ,the error message is: # /usr/sbin/mkdev -l aio0 mkdev: 0514-519 The following device was not found in the customized device configuration database: name = 'aio0' 2. Start ids is OK ,though failed to enable AIO.

This is not necessary on AIX 6.1: www.ibm.com/support/docview.wss?uid=swg21303183 Does "onstat -g iov" show "kio" entries? If so, it is using kernel AIO. Are you using raw devices? Regards, Doug Lawry "joe" <joeclhua@gmail.com> wrote in message news:bb5467fb-51bb-4796-9ae7-72fa18e5a83b@c34g2000pri.googlegroups.com... > os: AIX 6.1 > informix: ids11.5.fc6 > > Before AIX 5.x , To start ids ,It need to run 'mkdev -l aio0'. > But under AIX 6.1, there are two question bothering me. > > 1. can not enable AIO ,the error message is: > # /usr/sbin/mkdev -l aio0 > mkdev: 0514-519 The following device was not found in the customized > device configuration database: > name = 'aio0' > 2. Start ids is OK ,though failed to enable AIO.

#onstat -g iov IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up 00:01:14 -- 501344 Kbytes AIO I/O vps: class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/ wup errors tempops fifo 7 0 i 0.0 0 0 0 0 1 0.0 0 0 msc 6 0 i 0.0 1 0 0 0 2 0.5 0 1 aio 5 0 i 2.9 214 19 145 0 214 1.0 0 0 aio 8 1 i 0.0 3 0 3 0 3 1.0 0 0 pio 4 0 i 0.0 2 0 2 0 3 0.7 0 2 lio 3 0 i 0.0 2 0 2 0 3 0.7 0 2 I used cooked device.

--0016364c7ed3f8167a0480bd120e Content-Type: text/plain; charset=ISO-8859-1 If you use COOKED device or filesystem files for chunks you will only get KAIO enabled if you include the following ONCONFIG parameter: DIRECT_IO 1 Also, for best performance on AIX though you should set: DIRECT_IO 2 Instead so that IDS also enables the AIX CONCURRENT IO feature. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 1, 2010 at 4:21 AM, joe <joeclhua@gmail.com> wrote: > #onstat -g iov > > IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up > 00:01:14 -- 501344 Kbytes > > AIO I/O vps: > class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/ > wup errors tempops > fifo 7 0 i 0.0 0 0 0 0 1 > 0.0 0 0 > msc 6 0 i 0.0 1 0 0 0 2 > 0.5 0 1 > aio 5 0 i 2.9 214 19 145 0 214 > 1.0 0 0 > aio 8 1 i 0.0 3 0 3 0 3 > 1.0 0 0 > pio 4 0 i 0.0 2 0 2 0 3 > 0.7 0 2 > lio 3 0 i 0.0 2 0 2 0 3 > 0.7 0 2 > > I used cooked device. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > --0016364c7ed3f8167a0480bd120e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable If you use COOKED device or filesystem files for chunks you will only get K= AIO enabled if you include the following ONCONFIG parameter: DIRECT_= IO 1 Also, for best performance on AIX though you should set: DIRECT_IO 2 Instead so that IDS also enables the AIX CONCURRENT = IO feature. Art Art S. Kagel Advanced DataTo= ols (<a href=3D"http://www.advancedatatools.com">www.advancedatatools.com</= a>) IIUG Board of Directors (<a href=3D"mailto:art@iiug.org">art@iiug.org</a>)<= br> See you at the 2010 IIUG Informix Conference April 25-28, 2010<br= >Overland Park (Kansas City), KS <a href=3D"http://www.iiug.org/conf">ww= w.iiug.org/conf</a> Disclaimer: Please keep in mind that my own opinions are my own opinion= s and do not reflect on my employer, Advanced DataTools, the IIUG, nor any = other organization with which I am associated either explicitly, implicitly= , or by inference. =A0Neither do those opinions reflect those of other indi= viduals affiliated with any entity with which I am affiliated nor those of = the entities themselves. <div class=3D"gmail_quote">On Mon, Mar 1, 2010 at 4:21 AM, joe <spa= n dir=3D"ltr"><<a href=3D"mailto:joeclhua@gmail.com">joeclhua@gmail.com<= /a>> wrote: <blockquote class=3D"gmail_quote" style=3D"margin:= 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left= : 1ex;"> #onstat -g iov IBM Informix Dynamic Server Version 11.50.FC6 =A0 =A0 -- On-Line -- Up 00:01:14 -- 501344 Kbytes AIO I/O vps: class/vp/id s =A0io/s totalops =A0dskread dskwrite =A0dskcopy =A0wakeups = =A0io/ wup =A0errors tempops =A0fifo =A07 =A00 i =A0 0.0 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A00 =A0 =A0 =A0 = =A00 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A01 0.0 =A0 =A0 =A0 0 =A0 =A0 =A0 =A00 =A0msc =A06 =A00 i =A0 0.0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 =A00 =A0 =A0 =A0 = =A00 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A02 0.5 =A0 =A0 =A0 0 =A0 =A0 =A0 =A01 =A0aio =A05 =A00 i =A0 2.9 =A0 =A0 =A0214 =A0 =A0 =A0 19 =A0 =A0 =A0145 = =A0 =A0 =A0 =A00 =A0 =A0 =A0214 1.0 =A0 =A0 =A0 0 =A0 =A0 =A0 =A00 =A0aio =A08 =A01 i =A0 0.0 =A0 =A0 =A0 =A03 =A0 =A0 =A0 =A00 =A0 =A0 =A0 = =A03 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A03 1.0 =A0 =A0 =A0 0 =A0 =A0 =A0 =A00 =A0pio =A04 =A00 i =A0 0.0 =A0 =A0 =A0 =A02 =A0 =A0 =A0 =A00 =A0 =A0 =A0 = =A02 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A03 0.7 =A0 =A0 =A0 0 =A0 =A0 =A0 =A02 =A0lio =A03 =A00 i =A0 0.0 =A0 =A0 =A0 =A02 =A0 =A0 =A0 =A00 =A0 =A0 =A0 = =A02 =A0 =A0 =A0 =A00 =A0 =A0 =A0 =A03 0.7 =A0 =A0 =A0 0 =A0 =A0 =A0 =A02 I used cooked device. <div><div></div><div class=3D"h5">_________________________________________= ______ Informix-list mailing list <a href=3D"mailto:Informix-list@iiug.org">Informix-list@iiug.org</a> <a href=3D"http://www.iiug.org/mailman/listinfo/informix-list" target=3D"_b= lank">http://www.iiug.org/mailman/listinfo/informix-list</a> </div></div></blockquote></div> --0016364c7ed3f8167a0480bd120e--

joe wrote: > #onstat -g iov > > IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up > 00:01:14 -- 501344 Kbytes > > AIO I/O vps: > class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/ > wup errors tempops > fifo 7 0 i 0.0 0 0 0 0 1 > 0.0 0 0 > msc 6 0 i 0.0 1 0 0 0 2 > 0.5 0 1 > aio 5 0 i 2.9 214 19 145 0 214 > 1.0 0 0 > aio 8 1 i 0.0 3 0 3 0 3 > 1.0 0 0 > pio 4 0 i 0.0 2 0 2 0 3 > 0.7 0 2 > lio 3 0 i 0.0 2 0 2 0 3 > 0.7 0 2 > > I used cooked device. This is a bit confusing. You are using AIO, but for that you don't need to to anything. You may want to use KAIO, and for that, when using cooked files you'll need to set DIRECT_IO to 1 or 2. 1 will use direct i/o and 2 will also use concurrent I/O (latest version on AIX only if I recall correctly). Regards.

Fernando Nunes wrote: > joe wrote: >> #onstat -g iov >> >> IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up >> 00:01:14 -- 501344 Kbytes >> >> AIO I/O vps: >> class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/ >> wup errors tempops >> fifo 7 0 i 0.0 0 0 0 0 1 >> 0.0 0 0 >> msc 6 0 i 0.0 1 0 0 0 2 >> 0.5 0 1 >> aio 5 0 i 2.9 214 19 145 0 214 >> 1.0 0 0 >> aio 8 1 i 0.0 3 0 3 0 3 >> 1.0 0 0 >> pio 4 0 i 0.0 2 0 2 0 3 >> 0.7 0 2 >> lio 3 0 i 0.0 2 0 2 0 3 >> 0.7 0 2 >> >> I used cooked device. > > This is a bit confusing. You are using AIO, but for that you don't need > to to anything. You may want to use KAIO, and for that, when using > cooked files you'll need to set DIRECT_IO to 1 or 2. 1 will use direct > i/o and 2 will also use concurrent I/O (latest version on AIX only if I > recall correctly). > > Regards. Ups... I should have read this more carefully. I checked the release notes and the URL already provided. So everything is working, and the release notes don't take 6.1 in consideration. Now You may still want to use DIRECT_IO. Please check the manual. Regards.

Similiar Articles:

ids11.5 enable AIO on AIX 6.1 - comp.databases.informix
os: AIX 6.1 informix: ids11.5.fc6 Before AIX 5.x , To start ids ,It need to run 'mkdev -l aio0'. But under AIX 6.1, there are two question bother...

IDS 11.50.xC6 is out... - comp.databases.informix
ids11.5 enable AIO on AIX 6.1 - comp.databases.informix IDS 11.50.xC6 is out... - comp.databases.informix ids11.5 enable AIO on AIX 6.1 - comp.databases.informix joe wrote ...

DRIVER ... - comp.protocols.snmp
how to enable sqlite driver how to erase a hard driver ... how to install aix print driver how to install an ... hp 1200 all-in-one 5.3 driver hp 1200 alternate driver

ids11.5 enable AIO on AIX 6.1 DataBase - DataBase Discussion List ...
os: AIX 6.1 informix: ids11.5.fc6 Before AIX 5.x , To start ids ,It need to run 'mkdev -l aio0'. But under AIX 6.1, there are two question bothering me.

ids11.5 enable AIO on AIX 6.1 - comp.databases.informix | Computer ...
os: AIX 6.1 informix: ids11.5.fc6 Before AIX 5.x , To start ids ,It need to run 'mkdev -l aio0'. But under AIX 6.1, there are two question bother...

7/22/2012 5:14:44 AM