IDS Forum

RE: kill idle session

Posted By: Aurelio DE LISIO
Date: Wednesday, 22 February 2017, at 12:14 p.m.

hi Lu,

Try this as alternative to API task [checked in IDS11.50]:

SELECT s.sid,

dbinfo('UTC_TO_DATETIME',s.connected) connect_tm,

dbinfo('UTC_TO_DATETIME',t.last_run_time) last_run_tm,

DBINFO('UTC_CURRENT') - t.last_run_time idle_tm
FROM sysmaster:syssessions s,

sysmaster:systcblst t,

sysmaster:sysrstcb r
WHERE t.tid = r.tid
AND s.sid = r.sid
;

It returns idle_time in seconds

aurelio

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Wednesday, February 22, 2017 12:35 PM
To: ids@iiug.org
Subject: Re: kill idle session [38673]

Lu:

You should be aware that such a task already exists in the sysadmin database ph_task table. The function is idle_user_timeout(). The timeout period is set in the ph_threshold table and defaults to 60 seconds:

> select * from ph_threshold where task_name = 'idle_user_timeout';

id 6
name IDLE TIMEOUT
task_name idle_user_timeout
value 60
value_type NUMERIC
description Maximum amount of time in minutes for non-informix users to be idl

e.

1 row(s) retrieved.

You just have to enable the task and set its periodicity. As far as your actual question:

> select * from syssessions where sid = 49989;

sid 49989
username art
uid 1000
pid 8002
hostname galadriel-ii
tty /dev/pts/1
connected 1487762864
feprogram /opt/informix/infmx.12.10.FC8WE/bin/dbaccess
pooladdr 1979437120
is_wlatch 0
is_wlock 0
is_wbuff 0
is_wckpt 0
is_wlogbuf 0
is_wtrans 0
is_monitor 0
is_incrit 0
state 524321

1 row(s) retrieved.

> select dbinfo( 'utc_to_datetime', connected ) from syssessions where
> sid
= 49989;

(expression)

2017-02-22 06:27:44

1 row(s) retrieved.

Art

Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

On Tue, Feb 21, 2017 at 11:58 PM, CHUAN LU <luchuan@cn.ibm.com> wrote:

> HI,
>
> In the development environment, some user connect to database with
> ISQL, query the data and doesn't quit for a long time, and sometimes
> they hold the locks.
>
> I want to write a shell script to kill those session that is idle for
> 10 minutes. I check the syssessions tables, it has a integer column
> named connected, How to know the login timestamp of the session?
> thanks for your time.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--f403045cf4e442a0c105491ce161

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

Messages In This Thread

• RE: kill idle session
  Aurelio DE LISIO -- Wednesday, 22 February 2017, at 12:14 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.