Re: Using Informix Online on SCO with KAIO

Paul Mahoney wrote: > We have just installed Informix Online 7.23 on a SCO 5.0.2 system > and have enabled KAIO (Kernel Asynchronous I/O). > > While testing, Informix fell over and the following message was logged > in /usr/adm/message: > > CPU3: CONFIG: aio_breakup -s AIO request table overflow > (NAIOREQ = 120 exceeded) > > So we reconfigure the kernel, having increased all KAIO relevant tunable > parameters to the SCO recommended maximums: > > NAIOPROC 16 > NAIOREQ 200 > NAIOBUF 200 > NAIOHBUF 50 > NAIOREQPP 200 > NAIOLOCKTBL 20 > > The system fell over again... > > CPU3: CONFIG: aio_breakup -s AIO request table overflow > (NAIOREQ = 200 exceeded) > > Informix have yet to tell us how we should determined workable values > for these tunable parameters. We don't know what the dependancies are. I don't know anything about what you should *expect* Informix to consume. But I don't think there would be any problem setting the kernel parameter higher than the "recommended" value. Kernel parameter maxima ought to be real hard maxima, and some are, but not this one. It's just someone's guess "nobody will ever need more than this" ("nobody will ever need more than 640K of RAM..."). >Bela< -- Sandy & Bela Lubkin are traveling around the world for a year! Telecommuting from Edinburgh, Scotland; Ireland next. +Please do not Cc: me on news posts! Our stories and pictures are at: http://www.armory.com/~alexia/trip/trip.html