IDS Forum

Re: Is there way to get idle session?

Posted By: John Miller iii
Date: Tuesday, 22 March 2016, at 11:13 a.m.

In Response To: Re: Is there way to get idle session? (Fernando Nunes)

One thing to consider when just doing network traffic to determine idle
time is
that a user can send to the server a large query and the engine works on
this
query for several hours without sending a message to the server. I would
not
call this session idle, but if you just look at network time they you
would.

I believe the idle=5Fsession task looks at the

CURRENT - DBINFO("utc=5Fto=5Fdatetime",last=5Frun=5Ftime) > time=5Fallowed

John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)

ids-bounces@iiug.org wrote on 03/22/2016 08:00:11 AM:

> From: "Fernando Nunes" <domusonline@gmail.com>
> To: ids@iiug.org
> Date: 03/22/2016 08:02 AM
> Subject: Re: Is there way to get idle session? [36815]
> Sent by: ids-bounces@iiug.org
>
> Depends on your version how easy it is.
> If you have this:
>
> { network IO Information }
>
> create table informix.sysnetworkio
>
> (
>
> net=5Fid int, { Net
> ID }
>
> sid int, { session
> id }
>
> net=5Fnetscb int8, { address of
> netscb }
>
> net=5Fclient=5Ftype int, { client
> type }
>
> net=5Fclient=5Fname char(12), { client protocal
> name }
>
> net=5Fread=5Fcnt int8, { number of read
> operations }
>
> net=5Fread=5Fbytes int8, { # of bytes txfr to
> server }
>
> net=5Fwrite=5Fcnt int8, { number of write
> operations }
>
> net=5Fwrite=5Fbytes int8, { # of bytes txfr to
> client }
>
> net=5Fopen=5Ftime int, { time connection was
> made }
>
> net=5Flast=5Fread int, { time of last network
> read }
>
> net=5Flast=5Fwrite int, { time of last network
> write }
>
> net=5Fstate int, { state of network
> connection }
>
> net=5Foptions int, { sqlhost
> options }
>
> net=5Fprot=5Fid int, { id for protocal
> name }
>
> net=5Fprotocol char(10), { prtocal
> name }
>
> net=5Fserver=5Ffd int, { poll server
> fd }
>
> net=5Fpoll=5Fthread int { poll thread
> id }
>
> );
>
> on your sysmaster, just check the net=5Flast=5Fread/net=5Flast=5Fwrite. I=
t should

> be a Unix time stamp which you can convert to a DATETIME YEAR TO SECOND
> with DBINFO().
> Be aware of the daylight saving time difference.
>
> New versions will already have a task to do this:
>
> idle=5Fuser=5Ftimeout
>
> If you have an old version you may need to get this from:
>
> castelo@primary:informix-> onstat -g ntt
>
> IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 4 days
> 21:33:06 -- 287728 Kbytes
>
> global network information:
> #netscb connects read write q-free q-limits q-exceed
> alloc/max
> 10/ 15 47 1250 1287 5/ 6 135/ 10 0/
> 0 6/ 6
>
> Individual thread network information (times):
>
> netscb thread name sid open read write
> address
>
> 45f8ec78 sqlexec 1868 15:58:34 15:58:34 15:58:34
>
> "sid", "read" and "write"
>
> Regards
>
> On Tue, Mar 22, 2016 at 2:45 PM, medkba <medkba@gmail.com> wrote:
>
> > Hi,
> >
> > Is there any way to get all the idle session i..e about 4 hours after
that
> > kill those session
> >
> > Thank you very much
> >
> > --001a1135f1441adb0a052ea44435
> >
> >
> >
> >
>
***************************************************************************=
****

> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --089e013cbd32a9e266052ea47619
>
>
>
***************************************************************************=
****

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

Messages In This Thread

• Is there way to get idle session?
  medkba -- Tuesday, 22 March 2016, at 10:45 a.m.
  • Re: Is there way to get idle session?
    Art Kagel -- Tuesday, 22 March 2016, at 10:59 a.m.
    • Re: Is there way to get idle session?
      medkba -- Tuesday, 22 March 2016, at 12:35 p.m.
      • Re: Is there way to get idle session?
        Art Kagel -- Tuesday, 22 March 2016, at 2:23 p.m.
  • Re: Is there way to get idle session?
    Fernando Nunes -- Tuesday, 22 March 2016, at 11:00 a.m.
    • Re: Is there way to get idle session?
      medkba -- Tuesday, 22 March 2016, at 11:05 a.m.
    • Re: Is there way to get idle session?
      John Miller iii -- Tuesday, 22 March 2016, at 11:13 a.m.
      • Re: Is there way to get idle session?
        Fernando Nunes -- Tuesday, 22 March 2016, at 11:31 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.