RE: ONCONFIG and AIX

Posted in 2006

Doug Conrey — Thu, 27 Jul 2006 13:11:13 -0600 — source: Usenet: comp.databases.informix

> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feedback, comments, etc. > > We are currently on IDS 10.FC4 on HP-UX 11 > - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 > > I have gotten this message in the log while performing some loads/alter > tables/indexes, etc > in development phase. > "13:33:20 KAIO: out of OS resources, errno = 11, pid = 282828" > > I decided to turn off KAIO, which is what we have in our current Prod > OLTP system on the HP's. > Here is my ONCONFIG - thanks! > Tom > We've run into this as well, and after chasing the issue around with AIX and IDS support, the solution we came up with was setting the IFMX_AIXKAIO_NUM_REQ environment variable. Apparently it determines the number of KAIO control blocks that can be allocated, and runs up to 4K (the default is 1K, I believe). We set it to 3K and haven't seen the error since. Also note that the error never actually seemed to produce any errors, it just slowed things down. DC