Re: Auto-disconnection for idle session
This is a multi-part message in MIME format.
------=_NextPart_000_00FE_01BE900E.4E54BA30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Hi,
Here is my script written in perl. There are some things, which must be done
manualy:
1. Execute: $ onstat -g ntt > mdm.dat
2. Clear header information and all important threads. It's fastest and
savest to do it by hand. :)
3. Run: killThread.pl and hope everything will be OK.
HTH.
Best regards,
Milen.
-----Original Message-----
From: David Andrieu <dandrieu@atmel.fr>
To: <informix-list@iiug.org>
Date: 20 ''''' 1999 18:48
Subject: Auto-disconnection for idle session
>Hi List,
>
> with onstat -g ntt, you can determine the last date when
>a user process (sqlexec) read or write in the database. Does
>anybody have already written a shell script to disconnect
>session idle for more than an hour (or a certain amount of time)?
>
>TIA,
>
>David Andrieu
>
>
------=_NextPart_000_00FE_01BE900E.4E54BA30
Content-Type: application/octet-stream;
name="killThread.pl"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="killThread.pl"
#!/usr/local/bin/perl
open( THREADS, "mdm.dat" );
$sheeps =3D 0;
while( <THREADS> ) {
$line =3D $_;
if( $line =3D~ /^\\S/ ) {
( $netscb, $name, $sid, $open, $read, $write, @junk ) =3D split /\\s+/, =
$line;
}
else {
$line =3D~ /^\\s+(\\S+)\\s+(\\S+)\\s+(\\S+)$/;
if( ( defined( $2 ) && defined( $3 ) ) ) {
print "Killing Thread # $sid ... ";
system( "/informix/bin/onmode -z $sid" );
print "OK\\n";
$sheeps++;
}
}
}
print "\\n\\nI've just killed $sheeps!\\n";
------=_NextPart_000_00FE_01BE900E.4E54BA30
Content-Type: application/octet-stream;
name="mdm.dat"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="mdm.dat"
415e59ac sqlexec 3758 11:46:16 11:46:16 11:46:16 =
=20
4172bf48 sqlexec 3742 11:44:47 11:44:47 11:44:47 =
=20
424d2d20 sqlexec 3740 11:43:25 11:46:14 11:46:14 =
=20
41527c94 sqlexec 3736 11:40:39 11:40:40 11:40:40 =
=20
40ef4a14 sqlexec 3732 11:35:12 11:40:14 11:40:14 =
=20
405e39d0 sqlexec 3728 11:31:29 11:31:29 11:31:29 =
=20
40fb3e10 sqlexec 3726 11:31:29 11:31:57 11:31:57 =
=20
40fb9c14 sqlexec 3720 11:21:34 11:46:11 11:46:11 =
=20
4151d914 sqlexec 3704 11:05:33 11:05:33 11:05:33 =
=20
4042460c sqlexec 3703 11:05:33 11:06:14 11:06:14 =
=20
41309848 sqlexec 3700 11:03:02 11:03:02 11:03:02 =
=20
40888920 sqlexec 3699 11:03:02 11:44:26 11:44:26 =
=20
40fbee50 sqlexec 3695 10:53:50 11:11:06 11:11:06 =
=20
41539404 sqlexec 3694 10:52:43 10:52:43 10:52:43 =
=20
40429c14 sqlexec 3693 10:52:42 11:36:08 11:36:08 =
=20
41b48704 sqlexec 3688 10:45:15 10:46:36 10:46:36 =
=20
424d2b04 sqlexec 3678 10:41:17 10:41:17 10:41:17 =
=20
41724f90 sqlexec 3677 10:41:17 11:46:16 11:46:16 =
=20
425bbf98 sqlexec 3674 10:39:42 10:39:42 10:39:42 =
=20
40fc259c sqlexec 3673 10:39:42 11:46:11 11:46:11 =
=20
4150e198 sqlexec 3666 10:33:27 10:33:28 10:33:28 =
=20
405fbab8 sqlexec 3665 10:33:27 11:45:22 11:45:22 =
=20
40c91270 sqlexec 3656 10:25:48 10:25:48 10:25:48 =
=20
425bf5e8 sqlexec 3655 10:25:48 11:46:16 11:46:16 =
=20
40fc7a78 sqlexec 3646 10:19:58 10:19:58 10:19:58 =
=20
41a6d5f4 sqlexec 3645 10:19:57 10:42:05 10:42:05 =
=20
40a93c78 sqlexec 3643 10:18:11 10:18:12 10:18:12 =
=20
4059d8c8 sqlexec 3642 10:18:11 10:18:49 10:18:49 =
=20
40fb3014 sqlexec 3641 10:17:20 11:34:34 11:34:34 =
=20
41539ce8 ontape 3639 10:17:16 11:46:18 11:46:18 =
=20
41a7e7a0 sqlexec 3633 10:15:24 10:15:24 10:15:24 =
=20
40fc9aa0 sqlexec 3632 10:15:23 10:15:59 10:15:59 =
=20
405e2f3c sqlexec 3628 10:12:42 10:12:42 10:12:42 =
=20
41300308 sqlexec 3627 10:12:42 11:41:14 11:41:14 =
=20
40fbecd4 sqlexec 3624 10:11:18 10:11:19 10:11:19 =
=20
40956c4c sqlexec 3623 10:11:17 10:11:33 10:11:33 =
=20
41728704 sqlexec 3622 10:10:47 10:10:47 10:10:47 =
=20
41a8578c sqlexec 3621 10:10:47 11:44:00 11:44:00 =
=20
4148bee4 sqlexec 3620 10:09:05 10:09:05 10:09:05 =
=20
40fb58f4 sqlexec 3619 10:09:05 10:09:05 10:09:05 =
=20
4015c438 sqlexec 3618 10:09:04 10:09:50 10:09:50 =
=20
40a3434c sqlexec 3617 10:09:04 10:09:36 10:09:36 =
=20
407ff3a4 sqlexec 3612 10:00:19 10:00:19 10:00:19 =
=20
41a78cdc sqlexec 3611 10:00:19 11:45:36 11:45:36 =
=20
60252c40 sqlexec 3607 09:56:33 09:56:33 09:56:33 =
=20
409ee600 sqlexec 3606 09:56:33 11:24:47 11:24:48 =
=20
40f0c014 sqlexec 3601 09:50:25 09:50:25 09:50:25 =
=20
40c68890 sqlexec 3600 09:50:25 10:16:16 10:16:16 =
=20
406d1c40 sqlexec 3599 09:49:42 09:49:42 09:49:42 =
=20
40d0f72c sqlexec 3598 09:49:42 11:43:56 11:43:56 =
=20
424cf5b0 sqlexec 3594 09:48:08 09:48:08 09:48:08 =
=20
408ab790 sqlexec 3593 09:48:08 11:41:02 11:41:02 =
=20
424cf864 sqlexec 3585 09:43:16 09:43:16 09:43:16 =
=20
40b8bc20 sqlexec 3584 09:43:16 11:41:12 11:41:12 =
=20
4082b790 sqlexec 3580 09:41:32 09:41:32 09:41:32 =
=20
4148b8f8 sqlexec 3579 09:41:31 10:32:33 10:32:33 =
=20
4076082c sqlexec 3578 09:41:22 09:41:22 09:41:22 =
=20
40c030ac sqlexec 3577 09:41:22 11:45:46 11:45:46 =
=20
415398a0 sqlexec 3576 09:40:57 09:40:58 09:40:58