IDS Forum

RE: Kill inactive persistent sessions

Posted By: Robert Roussey(IT)
Date: Friday, 6 June 2008, at 10:45 a.m.

In Response To: Re: Kill inactive persistent sessions (Kern Doe)

I think I spotted this SQL on www.informixfaq.com. Worked fine with IDS 10. Goes against the sysmaster db.

set isolation to dirty read;
SELECT -- s.sid as sid,

s.username[1,10] as user,

q.odb_dbname[1,10] database,

s.tty[1,12] as tty,
-- dbinfo('UTC_TO_DATETIME',s.connected) con_time,

dbinfo('UTC_TO_DATETIME',t.run_time) last_run,

current - dbinfo('UTC_TO_DATETIME',t.run_time) idle_time
FROM syssessions s,

systcblst t,

sysrstcb r,

sysopendb q
WHERE t.tid = r.tid AND s.sid = r.sid AND s.sid = q.odb_sessionid
ORDER BY 5 DESC

Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe
Sent: Thursday, June 05, 2008 5:14 PM
To: ids@iiug.org
Subject: Re: Kill inactive persistent sessions [12338]

Yes it should work for all threads. Many times, users connect to the database
via dbaccess then leave the sessions open; and onstat -g ntt should tell
whether they are active or not. In some cases, there are running away backup
threads, this should also help me to know.

----- Original Message ----
From: nestor gomez munoz <nestorgm@prodigy.net.mx>
To: ids@iiug.org
Sent: Thursday, June 5, 2008 5:04:06 PM
Subject: Re: Kill inactive persistent sessions [12337]

Hello. Taking advantage of this thread, I'd like to ask
¿does it work this command for a local dbaccess started process?
Thanks.
--Nestor
El jue, 05-06-2008 a las 15:29 -0400, Kern Doe escribió:
> Perhaps you may have to script this out by utilizing onstat -g ntt
> for example:
> onstat -g ntt | grep 2932
> 34d56018 sqlexec 2932 13:32:03 11:31:12 11:31:12
> ----
> date
> Thu Jun 5 15:20:18 EDT 2008
>
> then monitor the last 2 columns for a certain period of time; if this
doesn't
> change, the session is pretty much idle and can safely be killed with onmode
> -z 2932.
>
> ----- Original Message ----
> From: Emiliano Romero <eromero@sitrack.com>
> To: ids@iiug.org
> Sent: Thursday, June 5, 2008 1:50:18 PM
> Subject: Kill inactive persistent sessions [12333]
>
> Hi list! I'm having some problems with inactive persistent sessions. I have
> some app that IS NOT working properly and it's keeping open sessions in
> Informix. I know I have to fix that app. But while the app is fixed, is
> there some way of setting a timeout of persistent connections in Informix? I
> want sessions that don't have activity in 5 minutes to be killed.
>
> Thanks in advice and Regards,
>
> Emiliano S. Romero
>
> This message is for the designated recipient only and may contain
privileged,
> proprietary, or otherwise private information.
> If you have received it in error, please notify the sender immediately and
> delete the original. Any other use of the email by you is prohibited.
>
>
>

*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>

*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Kill inactive persistent sessions
  Emiliano Romero -- Thursday, 5 June 2008, at 1:50 p.m.
  • RE: Kill inactive persistent sessions
    Robert Roussey(IT) -- Thursday, 5 June 2008, at 2:05 p.m.
    • RE: Kill inactive persistent sessions
      Emiliano Romero -- Thursday, 5 June 2008, at 2:48 p.m.
  • Re: Kill inactive persistent sessions
    Kern Doe -- Thursday, 5 June 2008, at 3:29 p.m.
    • Re: Kill inactive persistent sessions
      nestor gomez munoz -- Thursday, 5 June 2008, at 5:04 p.m.
      • Re: Kill inactive persistent sessions
        Kern Doe -- Thursday, 5 June 2008, at 5:14 p.m.
        • RE: Kill inactive persistent sessions
          Robert Roussey(IT) -- Friday, 6 June 2008, at 10:45 a.m.
          • RE: Kill inactive persistent sessions
            Mark Tyrer -- Monday, 9 June 2008, at 5:35 a.m.
            • RE: Kill inactive persistent sessions
              John Miller iii -- Monday, 9 June 2008, at 10:44 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.