cancel
Showing results for 
Search instead for 
Did you mean: 

Informix KAIO error message

SOLVED
Go to solution
Jens Ebert
Frequent Advisor

Informix KAIO error message

During a dbimport of a large database we get many errors:

11:14:20 hpkaioaddseg: ASYNC_ADDSEG
errno = 12 Not enough space
11:14:20 hpkaioaddseg: ASYNC_ADDSEG
errno = 12 Not enough space
11:14:20 Dynamically allocated new virtual
shared memory segment (size 8192KB)

In the documentation notes for HP there is a hint for this error:
"KAIO: out of OS resources, errno = 21 ..."
IFMX_HPKAIO_NUM_REQ=;
but this one looks different to me.

Anyone can help?

We have IDS.2000 (9.21) on HP-UX 11.0

Jens
9 REPLIES
Rainer_1
Honored Contributor

Re: Informix KAIO error message

For errno 12 i found at /usr/include/sys/errno.h:

#define ENOMEM 12 /* Not enough core */

At 'man errno' i found:

[ENOMEM] Not enough space. During a system call such as exec(), brk(), fork(), or sbrk(), a program asks for more space than the system is able to supply. This may not be a temporary condition; the maximum space size is a system parameter. The error can also occur if there is not enough swap space during a fork().

Think you have to check your kernel parameters.
Jens Ebert
Frequent Advisor

Re: Informix KAIO error message

Rainer, thank you for responding. The manual page states "the maximum space size is a system parameter" - I wonder which of the many this might be ?

Jens
Rainer_1
Honored Contributor

Re: Informix KAIO error message

my guess is the shmmax parameter because the last error you posted has the message: 'dynamically allocated new virtual shared memory segment'
Darrel Louis
Honored Contributor

Re: Informix KAIO error message

Don't know if you have glance to measure the process tables.
- Check with swapinfo -t if you have enough swapspace.
- Check what the maxdsiz is aswell.
Darrel Louis
Honored Contributor

Re: Informix KAIO error message

To check if the size for SHMVIRTSIZE is big enough, use the ?onstat ?g seg? command.
If there is an extra entry for the virtual segment, this indicates that either your SHMVIRTSIZE is to small or there was a process, that needed extra virtual memory. The extra segment will have the size of SHMADD.



Colin Taberman
Occasional Contributor
Solution

Re: Informix KAIO error message

This message is generated by the Informix engine when KAIO is active and the initial virtual shared memory segment is not large enough. If Informix needs to create another on start-up 'SHMADD' then this causes this error to appear. Ensure that SHMVIRTSIZE is large enough in your Informix ONCONFIG and restart.

Beware using KAIO with Informix releases <= 7.24.
Merlin the happy pig
Occasional Contributor

Re: Informix KAIO error message

We find that imports/recoveries with KAIO operational often fail and we therefore turn it off in the informix user profile before starting the import - unset KAION and then export KAIOOFF=1
A Headless Chicken does not stop for a Haircut
Jens Ebert
Frequent Advisor

Re: Informix KAIO error message

How does the environment variable KAIO work?

Do I have to set it in the shell that starts the database with oninit and KAIO will be used for all operations for any user?
Or do I have to set it for any shell that accesses the database?

Thank you, Jens
Darrel Louis
Honored Contributor

Re: Informix KAIO error message

Hi,

You need to set it in the .profile of the informix user, which start the Informix Instance.