Re: Memory Leak

Venky9970@aol.com wrote: > > Hi, > > We are currently using Informix-Online DSA 7.11 UC1 on Unisys SVR4 1.4 > and are planning to migrate to Online DSA 7.20 UC2. Currently we are > bringing database down and up in our daily batch due to shared memory leak > in previous versions. we are using informix two phase commit in esql > programs > for replicating data from one server to another. > > I would like to know what scenario's can cause memory leaks in DSA 7.20 UC2 > and how can I realize and overcome it. Because we are planning to remove the > database down and up scripts from our daily batch and run them once in a > week. > > Thanks for your help in Advance > > Venky In version 7.11 applications can cause a memory problem, if the app. never free's a cursor or a prepared statement. Some app. prepare a dynamic sql statement and either forget to free the statement-id or perform the free statement very late. The FREE statement in 7.11 gave the memory back to the session, not to the server. Therefore the memory allocated by an application was reserved for the session and if your session didn't terminate this memory was lost forever. ( tip: monitor the "ralloc" pool of the sessions ) Meanwhile, this problem seems to be fixed, but I don't know if it was a bug. I did the test using version 7.22UC1 on HP-UX 10.10. When I closed a CURSOR, the memory was freed immediately and available for the server. Bye Stefan