Re: Informix 7.13 "eating" memory

Paul Leskinen 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: > > main() > { > exec sql BEGIN DECLARE SECTION; > decimal(10,0) institution; > exec sql END DECLARE SECTION; > > int count; > > /* Get stuff ready */ > > printf("opening database...\\n"); > exec sql database u_switch; > > /* Loop it */ > > for(count=0;count<10000;count++) > { > exec sql select institution into :institution from device > where device_id=13; > > printf("%d\\n",count); > } > exec sql close database; > } > > > 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 I do an onmode -F every hour to free up memory from cron.