Clive
When investigating a suspected memory leak, I run something like this...
for i in $(onstat -g ses | grep -v informix | awk '{print $8":"$5":"$1}' | sort -nr | head -5)
do
sessID=$(echo $i | cut -d ":" -f 3)
onstat -g ses $sessID
done >> /tmp/mySessIDs.txt
...and that gives me the
onstat -g ses output for the top 5 memory hungry user sessions.
I'm not touching the system tables, but it's useful when you don't know which sessions to initially target.
------------------------------
Kirit Rana
------------------------------
Original Message:
Sent: Wed February 17, 2021 07:30 AM
From: Clive Eisen
Subject: monitoring session memory
IDS 11.70FC4
I 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 like
get session size
execute (for example) a stored procedure
get session size
Is there any sql I can run that will return the session memory information like you get from
onstat -g ses $sessionid?
TIA
------------------------------
Clive Eisen
------------------------------
#Informix