Steve,

See the following entry to which Roy helped me suss out...We quite
happily remove server sessions with IMADB on a nightly basis :

http://www.thetechtwo.com/detail-7634389.html


Best Regards

Graham T Newlands
IT Consultant
Fujitsu Australia

Address:
Lvl 20, 222 Exhibition St, Melbourne, VIC 3000
Tel:
+61 3 9657 8705
Mobile:
0404 003 104
Fax:
+61 3 9664 6570
Email:
graham.newlands (AT) au (DOT) fujitsu.com
Web site:
http://au.fujitsu.com




-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of
info-ingres-request (AT) cariboulake (DOT) com
Sent: Wednesday, 14 September 2005 3:00 AM
To: info-ingres (AT) cariboulake (DOT) com
Subject: Info-ingres digest, Vol 1 #339 - 3 msgs

Send Info-ingres mailing list submissions to
info-ingres (AT) cariboulake (DOT) com

To subscribe or unsubscribe via the World Wide Web, visit
http://mailman.cariboulake.com/mailm...py/info-ingres
or, via email, send a message with subject or body 'help' to
info-ingres-request (AT) cariboulake (DOT) com

You can reach the person managing the list at
info-ingres-admin (AT) cariboulake (DOT) com

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Info-ingres digest..."


Today's Topics:

1. Script to remove user sessions from a DB (Steve McElhinney)
2. Re: Script to remove user sessions from a DB (Roy Hann)
3. SIUA Meeting, 22nd September (Tonyd08068 (AT) netscape (DOT) net)

--__--__--

Message: 1
From: "Steve McElhinney" <stevem (AT) 141 (DOT) com>
Date: 13 Sep 2005 03:23:56 -0700
Organization: http://groups.google.com
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Script to remove user sessions from a DB

Part of our batch work requires exclusive access to a livedb, so we need
a UNIX script to remove all user sessions from the database.

We currently have a script that runs iinamu to get the server id's then
iimonitor to get the session id's, then runs 'remove session' in
iimonitor.

This all works swimmingly, but the code is quite complicated...
I was wondering if there is a better, simpler way to remove user
sessions?

Env is Ingres 2.5 & 2.6 on AIX 5.2

TIA Steve


--__--__--

Message: 2
Reply-To: "Roy Hann" <specially (AT) processed (DOT) almost.meat>
From: "Roy Hann" <specially (AT) processed (DOT) almost.meat>
Date: Tue, 13 Sep 2005 12:24:09 +0100
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Re: Script to remove user sessions from a DB

"Steve McElhinney" <stevem (AT) 141 (DOT) com> wrote

Connect to imadb then EXECUTE PROCEDURE IMA_DROP_SESSIONS;

Roy Hann (rhann at rationalcommerce dot com) Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"



--__--__--

Message: 3
Date: Tue, 13 Sep 2005 10:01:17 -0400
From: Tonyd08068 (AT) netscape (DOT) net
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] SIUA Meeting, 22nd September

Hi there,

In case there are Ingres users in Scotland (or nearby !) who aren't on
my mailing list, just a quick note to let you know that the Scottish
Ingres Users Association will be holding its next meeting on the 22nd
September (a week on Thursday). The meeting will be in the Radisson SAS
hotel in Glasgow (a couple of minutes from Glasgow Central railway
station), and there is no charge for attending. Our agenda currently
looks like this :

9:30 - 9:45 - Welcoming remarks
9:45 - 10:30 - What's new with Ingres & CA - Jim Callaghan 10:30 - 10:45
- Coffee
10:45 - 11:45 - Migration to Ingres Release 3 - CA
11:45 - 12:30 - CA Training & the latest on CA World 05 12:30 - 13:15 -
Lunch
13:15 - 14:00 - OpenRoad eClient - CA
14:00 - 15:00 - The Pitfalls of Rollforwarddb - Martin Bowes 15:00 -
15:15 - Coffee
15:15 - 16:15 - OpenRoad AppServer - Neil Warnock 16:00 - 16:30 - Q & A
and Close

So hopefully something there of interest ! If you want to come along,
please drop an email to SIUAnews (AT) netscape (DOT) net with your name, and any
colleagues you'd like to bring along.

Thanks,

- Tony

Tony Douglas
Chair,
Scottish Ingres Users Association

__________________________________________________ ________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at
http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer Search from anywhere on the
Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp


--__--__--

_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


End of Info-ingres Digest


This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscribe (AT) au (DOT) fujitsu.com