Re: Sudden & massive SHMADD activity; engine went BANG!

Did the application software change recently. We had exactly the same problem on Mar 10 2004 when it added 8 SHMADD in 15 min and engine died. It was finally traced to sloppy coding in JDBC where they kept recycling the result set, leading to memory leaks in Informix session. To convince everyone that the fault was in our coding and not in Informix (ver 9.21), I wrote a pretty sophisticated script in perl using onstat etc which maps out the open cursors and memories of every session. I put that in an alert script which was mailing it to me every 15 minutes. Using that it was pretty easy to identify rogue sessions causing the leak and we eventually identified the code in question. If u want the script I can mail it to you.