Re: Memory not getting freedup when the sessions are open

In article <3365459D.1749@mail.tammany.com>, Andrew Simpson <guides@mail.tammany.com> writes > >Reddy Duggempudi wrote: >> >> Hi: >> >> We are running 1.02UC2 newera & Online 7.14UD2 on AIX 4.1.4. >> We have about 30-50 users. Each session sometimes uses upto >> 20MB of memory (shown in onstat -g ses). This memory is not >> getting freed up. We tried onmode -F. But this did not do >> any good. >> >> I heard that Informix keeps the memory for each session as >> it uses it, assuming that the user is likely to ask for more. >> Is this true? If so, is there a solution to our problem >> other than kicking out the users every night? >> >> FYI, we verified our client code to see of any open cursors etc. >> nothing was found. >> Remember that wiht 4GL version 6 you must not only close a cursor but also a) FREE the cursor b) FREE the statement id associated with the cursor :- PREPARE P1 from "select * from systables" ^ | | statement id is P1 c) If you do PREPARE P1 FROM "insert into mytab(1)" EXECUTE P1 also do FREE P1 Things changed.... >> thanks in advance, >> - Reddy > >Reddy, >We have the same problem. Stored Procedures seem to be the biggest >memory hogs. >We have contacted Informix and have not received a solution. >Drew -- David Williams