IDS Forum

RE: Kill inactive persistent sessions

Posted By: John Miller iii
Date: Monday, 9 June 2008, at 10:44 a.m.

In Response To: RE: Kill inactive persistent sessions (Mark Tyrer)

Might want to check this blog out. It explains how to kill idle users =
with
version
11 and have it run inside the database server and be control by the
graphical
OpenAdmin Tool or direct SQL.

http://www-128.ibm.com/developerworks/blogs/page/idsteam?entry=3Dtermin=
ate_idle_users_with_the

John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)

=

"Mark Tyrer" =

<mark.tyrer@rtt.c =

o.za> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

RE: Kill inactive persistent =

06/09/2008 02:35 sessions [12346] =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hi all,

This is useful stuff - we have a lot of automatic processes that connec=
t to

the database and sometimes fail to drop the session when they are done.=

Here is the script for killing sessions older than 24 hours based on th=
e
SQL
that Robert Roussey posted. Actually mine has a few user filters specif=
ic
to
my site. I am running on Informix 10 FC5

for i in $(dbaccess sysmaster 2>/dev/null << EOF|tail +4

set isolation to dirty read;

SELECT s.sid as sid
FROM syssessions s,

systcblst t,

sysrstcb r,

sysopendb q
WHERE t.tid =3D r.tid AND s.sid =3D r.sid
AND s.sid =3D q.odb_sessionid
AND (current year to day -
dbinfo('UTC_TO_DATETIME',t.run_time))::char(10)::integer > 0
EOF
)
do
echo onmode -z $i
onmode -z $i
done

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Robert
Roussey(IT)
Sent: 06 June 2008 04:46 PM
To: ids@iiug.org
Subject: RE: Kill inactive persistent sessions [12344]

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 syssessio=
ns
s,

systcblst t,

sysrstcb r,

sysopendb q
WHERE t.tid =3D r.tid AND s.sid =3D r.sid AND s.sid =3D 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 K=
ern
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 a=
way
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 =BFdoes 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=F3:
> Perhaps you may have to script this out by utilizing onstat -g ntt fo=
r
> 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 ap=
p
> 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 immediatel=
y
> and delete the original. Any other use of the email by you is prohibi=
ted.

>
>
>

***********************************************************************=
*****

***
> 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.

***********************************************************************=
*****

***
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.