Informix online shmat error !!

Hi, can anyone help me to solve this problem !!!! lines from online.log .../ 10:17:03 shmat: [ENOMEM][12]: out of available data space, check systemMAXMEM 10:17:03 out of virtual shared memory /... many lines like those two .../ 10:17:03 Assert Failed: WARNING! Unable to allocate a transaction foruser id 2 00, session id 0 10:17:03 Who:Session(712, informix@myhost.mydomain.fr, 17864, -2117739712) Thread(12, tlitcplst, 0, 1) 10:17:03 Results: Memory allocation error. 10:17:03 Action: Make more virtual memory available to OnLine 10:17:03 See Also: /tmp/af.cdeff 10:17:03 Assert Failed: Internal Error - Segmentation Violation 10:17:03 Who:Session(712, informix@myhost.mydomain.fr, 17864, -2117739712) Thread(12, tlitcplst, 0, 1) 10:17:03 Results: OnLine must abort 10:17:03 Action: Reinitialize shared memory 10:17:03 See Also: /tmp/af.cdeff 10:17:03 rsinit.c, line 9186, thread 12, proc id 580, Segmentation Violation. 10:17:03 PANIC: Attempting to bring system down What should I understand by 1)out of available data space, check system MAXMEM 2)Make more virtual memory available to OnLine in other words whats wrong ?! I can see in my online.log many lines like this dynamically allocated new shared memory segment (size 2097152) It seems that there are no more users as usually ! Plateform SCO OSR 5.02 Informix online 7.12 UC2 Quick help will be appreciate Thanks joel.quidort@branchur.fr

Joel QUIDORT <joel.quidort@branchur.fr> schrieb in im Newsbeitrag: 3792F1D6.48572CB3@branchur.fr... > Hi, > > can anyone help me to solve this problem !!!! > > lines from online.log > .../ > 10:17:03 shmat: [ENOMEM][12]: out of available data space, check system> MAXMEM > 10:17:03 out of virtual shared memory > /... many lines like those two> > .../ > 10:17:03 Assert Failed: WARNING! Unable to allocate a transaction for> user id 2 > 00, session id 0 > 10:17:03 Who:Session(712, informix@myhost.mydomain.fr, 17864, > -2117739712) > Thread(12, tlitcplst, 0, 1) > 10:17:03 Results: Memory allocation error. > 10:17:03 Action: Make more virtual memory available to OnLine > 10:17:03 See Also: /tmp/af.cdeff > 10:17:03 Assert Failed: Internal Error - Segmentation Violation > 10:17:03 Who:Session(712, informix@myhost.mydomain.fr, 17864, > -2117739712) > Thread(12, tlitcplst, 0, 1) > 10:17:03 Results: OnLine must abort > 10:17:03 Action: Reinitialize shared memory > 10:17:03 See Also: /tmp/af.cdeff > 10:17:03 rsinit.c, line 9186, thread 12, proc id 580, Segmentation > Violation. > 10:17:03 PANIC: Attempting to bring system down> > What should I understand by > > 1)out of available data space, check system MAXMEM > 2)Make more virtual memory available to OnLine > > in other words whats wrong ?! > > > I can see in my online.log many lines like this > dynamically allocated new shared memory segment (size 2097152) > > It seems that there are no more users as usually ! > > Plateform SCO OSR 5.02 > Informix online 7.12 UC2 > > Quick help will be appreciate > Thanks > > joel.quidort@branchur.fr > > > Hello Joel, the amount of shared memory use is not only depending on the number of concurrent users, but also on the tasks they are performing. Maybe setting SHMTOTAL in Your ONCONFIG to value different from 0 my help. Wolfgang

> 1)out of available data space, check system MAXMEM > 2)Make more virtual memory available to OnLine > > in other words whats wrong ?! You need to increase your SHMVIRTSIZE and SHMADD params. > > I can see in my online.log many lines like this > dynamically allocated new shared memory segment (size 2097152) > Look for this strings through your log since the last start. Then sum this values and let SHMVIRTSIZE = this sum. Then set SHMADD to about 0.5*SHMVIRTSIZE. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

In article <3792F1D6.48572CB3@branchur.fr>, Joel QUIDORT <joel.quidort@branchur.fr> wrote: >lines from online.log >.../ >10:17:03 shmat: [ENOMEM][12]: out of available data space, check system>MAXMEM >10:17:03 out of virtual shared memory >/... many lines like those two < snip >>1)out of available data space, check system MAXMEM >2)Make more virtual memory available to OnLine Informix is asking for more memory than the operating system is able to give it. If this is happening outside of initial startup, you may want to play with the Informix virtual segment size parms and make sure that your usual requirement is allocated up front. If not, check the release notes for your version of Unix and compare the suggested kernel parms against what you have. Some systems have more-or-less firm limits on the amount of shared memory that can be allocated system-wide (HP-UX comes to mind, since that's snookered me a few times). There are kernel parms for number of shared memory identifiers and number of shared memory segments per process that may also come in to play. Likely there is nothing (or very little) wrong with Informix. It's just the messenger. Start by looking at your OS configuration. Bonne chance! Jim -- W. Jim Jordan, Nortel Networks, Stop 29CA3A08 | +1 613 763 1568 PO Box 3511 Stn C, Ottawa, ON K1Y 4H7 Canada | wjjordan@nortelnetworks.com Opinions expressed are not necessarily those of Nortel Networks. Inbound spam filtering is in place. Don't send what I won't see.