Can somebody helpme !, a few days ago may IDS 7.3 is failing an the log show this:

15:52:32 Checkpoint Completed: duration was 0 seconds.
15:53:43 dynamically allocated new shared memory segment (size 8388608)

15:53:44 dynamically allocated new shared memory segment (size 8388608)

15:53:47 dynamically allocated new shared memory segment (size 8388608)

15:54:13 dynamically allocated new shared memory segment (size 8388608)

15:54:29 dynamically allocated new shared memory segment (size 8388608)

15:54:32 dynamically allocated new shared memory segment (size 8388608)

15:54:41 dynamically allocated new shared memory segment (size 8388608)

15:54:44 shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

15:54:44 shmat: [ENOMEM][12]: out of available data space, check system MAXMEM

15:54:44 out of virtual shared memory

It was stable for months,but suddenly it fails, Thanks for the Help.

Since all the requests for shared memory occured within second/minutes I'd say you have an application program, possibly a stored procedure, that's got a "run away" stack.

i think the first reply may be right. It is suspicious for this to happen all of a sudden. You should check with the developers for new code or have the number of connections, transactions or amount of data changed recently? Look for the sql in the AF file and identify the user.

Either way it is telling you there is no more memory on the machine. This will produce a crash. If this is the only instance on this machine and it is set to 0 and the additional memory needed is valid you will need more memory.

If there are others instances, RDBMS's, applications that could be taking the memory that should be allocated to Informix then something else needs to be done. When SHMMAX is set to 0 that means Informix can take whatever memory is available.

If SHMMAX was set to 1GB and on a normal day you used 500MB but then Informix needed the extra 500MB on day and only 300MB were available because something lese took the memory you would also see this message and a crash would result. A way to prevent this is to allocate all the Informix memory up front so no one else can take it. It takes away from being able to share which is what Informix does but If you like us and you must run "other" RDBMS's on the same machines it's in Informix's best interest to not share because no one else plays well. :-)

Regards,
DBAgirl

- Program from client cause this problem
- Your param. SHMADD is too small for live system
- Bug of CSDK version that's client program used to compiled and run

Thanks to all, yes was a new process, we search the new code and we found it.

Thanks a lot, from Mexico D.F.