Re: Informix 7.13 "eating" memory

Paul Leskinen (paul@csfi.com) wrote: : I was hoping that someone out there has encountered this problem: : We have an online transaction-processing application that stays resident : and processes financial transactions using Informix. The problem is that : Informix Online keeps allocating more and more shared memory for the : process(es). : We've actually seen the problem (on a smaller scale, of course) with the : following ESQL/C code: : The field names are not really important. When this program runs, we see : the "file table" memory pool expand apparently without bounds. (We did an : onstat -g ses xxx to obtain that information while the program is running). : One more note: When the program terminates, all shared memory allocated by : Informix is freed. An obvious solution would be for our OLTP to terminate : and restart once in awhile to avoid this problem--but that's kind of : unsightly behavior for a "continously" available application. : We're running version 7.13.UC1 of Online Dynamic Server on an NCR 3430 dual : Pentium running UNIX MP-RAS 2.03.00. We have ESQL/C ver. 7.13.UC1. : We've been going back and forth with Informix tech support for awhile with : no luck so far. : We're now behind schedule thanks to this little problem. Any help would be : greatly appreciated. : Paul Leskinen : Consolidated Systems of Florida Look at the Total Memory field in the onmonitor-parameters-shared memory option. If this field has a zero (0) value, saome process could eat all the memory, even the one reserved to the operating system. Bye, I hope it helps you, k -- ****************************************************** * Rodrigo Prenafeta * e-mail: rprenafe@dcc.uchile.cl * * * rprenafe@marinetti.cl * ******************************************************