topic Re: Informix KAIO error message in Operating System - HP-UX

Informix KAIO error message

Jens Ebert — Tue, 12 Dec 2000 11:43:55 GMT

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

Re: Informix KAIO error message

Rainer_1 — Tue, 12 Dec 2000 11:57:44 GMT

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.

Re: Informix KAIO error message

Jens Ebert — Tue, 12 Dec 2000 12:49:51 GMT

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

Re: Informix KAIO error message

Rainer_1 — Tue, 12 Dec 2000 13:11:52 GMT

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

Re: Informix KAIO error message

Darrel Louis — Tue, 12 Dec 2000 13:43:13 GMT

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.

Re: Informix KAIO error message

Darrel Louis — Tue, 12 Dec 2000 13:57:40 GMT

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.

Re: Informix KAIO error message

Colin Taberman — Tue, 12 Dec 2000 17:15:42 GMT

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.

Re: Informix KAIO error message

Merlin the happy pig — Tue, 12 Dec 2000 18:05:00 GMT

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

Re: Informix KAIO error message

Jens Ebert — Mon, 18 Dec 2000 11:17:15 GMT

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

Re: Informix KAIO error message

Darrel Louis — Mon, 18 Dec 2000 11:28:11 GMT

Hi,

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