Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Informix 1. unload 2. share memory

islau
Occasional Contributor

Informix 1. unload 2. share memory

Hi all,

For informix v7.x
1. If I unload a table, how can I estimate the unloaded dump file size?

2. I get the following errors in a informix database, but no such error in another informix database within the same server:


"Shmget: [ENOMEM][12]: key 525a4804: out of shared memory, check system max shared memory segment size.

Out of virtual memory
Could not create single shared memory segment with resident and non-resident partitions. Proceeding to create 2 shared memory segments instead"

Moreover, the cron job of informix showed the errors:

"sh: The fork function failed. Too many processes already exist."

Thahk you!

1 REPLY
Patrick Wallek
Honored Contributor

Re: Informix 1. unload 2. share memory

For the error "sh: The fork function failed. Too many processes already exist." it sounds like you are hitting either the maxuprc limit (max number of processes per user) or the nproc limit (max number of system wide processes). I would guess that maxuprc would be your culprit in this case.

Check those values in your kernel and see if they need to be increased.