Informix KAIO error message

[Jens Ebert]

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

[Rainer_1]

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]

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]

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

[Darrel Louis]

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]

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 · Accepted solution]

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]

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

[Jens Ebert]

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]

Hi,

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