Thank you all.
After further checking, I noticed that while the error message occurred, the mutex wait and the buffer wait of the INSERT session were continued. (Thanks to InformixHQ)
As shown in the screenshot, the time when the application that executes the INSERT statement in multiple sessions starts and the time when the error message occurs coincide. So I am guessing the problem is that the application causes excessive INSERTs at the same time. (About 300 sessions)
In summary, the IFMX_AIXKAIO_NUM_REQ environment variable, maxreqs setting, application logic improvement, and lru queue tuning should also be considered.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Wed June 17, 2020 06:34 PM
From: SangGyu Jeong
Subject: KAIO: out of OS resources, errno = 11
Hi,
The following message continuously occurs in online.log and a service delay occurs.
KAIO: out of OS resources, errno = 11, pid = 4784150
Below is the onstat -g sql result.
My customer is using Informix 12.10.FC6 on AIX, can setting the IFMX_AIXKAIO_NUM_REQ environment variable help solve the problem?
And how can I check if it has been applied?
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix