Join / Log in
IDS 11.70FC4I seem to be having some serious session memory leaks.Sadly it is intermittent.All the clients are using DBD::Informix (perl) to access the database.I have to run onmode -F quite frequently and restart some of the clients so it looks like something is not being closed correctly.I'd like to examine the session memory use from inside the session - so we can do things likeget session sizeexecute (for example) a stored procedureget session size
Is there any sql I can run that will return the session memory information like you get fromonstat -g ses $sessionid?
Try this one:> select memused, memtotal from sysscblst where sid = 503; memused memtotal 252728 266240 1 row(s) retrieved.Slightly different from the onstat output, but consistent:onstat -g ses 503 | head -7IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line -- Up 11:10:30 -- 2180172 Kbytes 2021-02-17 20:48:18session effective #RSAM total used dynamicid user user tty pid hostname threads memory memory explain503 art - 5 206295 localhost 1 245760 225384 off
Onstat –g afr can be useful as well