session/connection last used time

IDS 11.50 FC7 on redhat 4 I'm investigating an issue we have with a db connection pool adding more connections and consuming shared memory resources. I think there is a problem with existing connections not being used/closed but new ones being added instead. I know from the syssessions table how to find out when a connection was opened but does anyone know how to tell when a connection was last used. If I know a connections last used time I can close these as a temporary measure until I find the root cause.

Hello. I think this link could help you.... http://www-01.ibm.com/support/docview.wss?uid=swg21209482 Version 11.70 has already a function in sysadmin for this, called idle_user_timeout. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: david.fortune@ingenico.com > Subject: session/connection last used time [29396] > Date: Thu, 24 Jan 2013 07:20:44 -0500 > > IDS 11.50 FC7 on redhat 4 > > I'm investigating an issue we have with a db connection pool adding more > connections and consuming shared memory resources. I think there is a problem > with existing connections not being used/closed but new ones being added > instead. I know from the syssessions table how to find out when a connection > was opened but does anyone know how to tell when a connection was last used. > If I know a connections last used time I can close these as a temporary > measure until I find the root cause. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Take a look at the onstat -g ntt command. This will show you went a session was opened, the last time it read from the socket and the last time it wrote to the socket. Any sqlexec thread that hasn't read or written in a while is a candidate for what you're looking for. Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DAVID FORTUNE Sent: Thursday, January 24, 2013 6:21 AM To: ids@iiug.org Subject: session/connection last used time [29396] IDS 11.50 FC7 on redhat 4 I'm investigating an issue we have with a db connection pool adding more connections and consuming shared memory resources. I think there is a problem with existing connections not being used/closed but new ones being added instead. I know from the syssessions table how to find out when a connection was opened but does anyone know how to tell when a connection was last used. If I know a connections last used time I can close these as a temporary measure until I find the root cause. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks to all. The link supplied by Alexandre gave me the solution. David. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andrew Ford Sent: 24 January 2013 15:41 To: ids@iiug.org Subject: RE: session/connection last used time [29400] Take a look at the onstat -g ntt command. This will show you went a session was opened, the last time it read from the socket and the last time it wrote to the socket. Any sqlexec thread that hasn't read or written in a while is a candidate for what you're looking for. Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DAVID FORTUNE Sent: Thursday, January 24, 2013 6:21 AM To: ids@iiug.org Subject: session/connection last used time [29396] IDS 11.50 FC7 on redhat 4 I'm investigating an issue we have with a db connection pool adding more connections and consuming shared memory resources. I think there is a problem with existing connections not being used/closed but new ones being added instead. I know from the syssessions table how to find out when a connection was opened but does anyone know how to tell when a connection was last used. If I know a connections last used time I can close these as a temporary measure until I find the root cause. ************************************************************************ **** *** Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. About Ingenico (Euronext: FR0000125346 – ING) Ingenico is a leading provider of payment solutions, with over 20 million terminals deployed in more than 125 countries. Its 4,000 employees worldwide support retailers, banks and service providers to optimize and secure their electronic payments solutions, develop their offer of services and increase their point of sales revenue. More information on http://www.ingenico.com/ | http://twitter.com/Ingenico. This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. P Please consider the environment before printing this e-mail