IDS Forum

Re: Syssessions connected

Posted By: John Miller iii
Date: Friday, 19 September 2008, at 2:56 p.m.

In Response To: Syssessions connected (Tim Ertl)

Tim:

I wrote a deveoper works article on how to use the database scheduler
and the SQL cmd api to do this exact task. Check out the following.
I have copied the top of the article below.

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

http://www.ibm.com/developerworks/blogs/page/idsteam?entry=3Dterminate_=
idle_users_with_the

Terminate Idle Users with the Database Admin System

The Database Admin System is a framework that can simplify many tasks f=
or
DBAs, application developers and end users. In addition, these tasks ca=
n be
seamlessly integrated into a graphical admin system, such as, the OpenA=
dmin
Tool for IDS.

We will examine how a DBA can take advantage of the Database Admin Syst=
em
to solve a real life problem. The problem we are going to explore is to=
how
to remove users who have been idle for more than a specified length of
time, only during work hours. Prior to the database admin system a DBA
would utilize several different operating system tools, such as, shell
scripting and cron. In addition, if this is pre-packaged system these n=
ew
scripts and cron entries will have to be integrated into an installed
script. Lastly this needs to be portable across all supported platforms=
.

If you are to utilize the database Admin system you only have to add a =
few
lines to your schema file and you are done. Since this is only SQL you =
will
have the advantage of being portable across different flavors of UNIX a=
nd
Windows.

The components we are going to utilize are:

Database Scheduler

Alert System

User Configurable Thresholds

SQL Admin API

We are going to break the above problem into three separate parts.

1. Creating a tunable threshold for the idle time out

2. Develop a stored procedure to terminate the idle users

3. Schedule this procedure to run at regular intervals

=

"Tim Ertl" =

<tim@lmrgroup.com =

> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

Syssessions connected [13437] =

09/19/2008 09:38 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

I am attempting to write something to cleanup all the disconnected sess=
ions

on my 11.10 server automaticly. 9.4 never had this problem but my probl=
em
now is, the sysmaster-syssessions.connected variable.

Should show some sort of time yet it is an integer variable. I found it=

fully undocumented in the admin ref manual. All admin ref says is that =
it
is
"connected integer Time that user connected to the database server". Wh=
at
time format? What is this variable saying. All entries look like this:

1219588344

Being such a large number even for new users I can assume that it is no=
t
the
number of seconds connected. Maybe it is the time OF the connection, we=
ll
that would be in datatime format? So what is this thing?

Any thoughts or pointers welcome.

Thanks,,,,

Tim Ertl

413-442-9000 x6211

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

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

=

Messages In This Thread

• Syssessions connected
  Tim Ertl -- Friday, 19 September 2008, at 12:38 p.m.
  • RE: Syssessions connected
    Link, David A -- Friday, 19 September 2008, at 12:43 p.m.
    • Re: Syssessions connected
      Jairo Gubler -- Friday, 19 September 2008, at 12:58 p.m.
  • Re: Syssessions connected
    Richard Snoke -- Friday, 19 September 2008, at 1:43 p.m.
  • Re: Syssessions connected
    Art Kagel -- Friday, 19 September 2008, at 2:07 p.m.
    • RE: Syssessions connected
      Tim Ertl -- Friday, 19 September 2008, at 3:12 p.m.
      • Re: Syssessions connected
        Art Kagel -- Friday, 19 September 2008, at 4:43 p.m.
        • RE: Syssessions connected
          Tim Ertl -- Friday, 19 September 2008, at 4:59 p.m.
  • Re: Syssessions connected
    John Miller iii -- Friday, 19 September 2008, at 2:56 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.