Re: how to disconnect some people ?
From: "Ph. Chantry" <chantry@seditel.REMOVE.fr>
>
>Today, we disconnect people with "onmode -ky" or "onmode -uy" commands.
>
>Is it a way to disconnect only people who's connected to ONE given database
>?
That's what I like about the French -- they're so subtle and smooth... :-)
1. Do an
onstat -g sql
-- this will help you find the session ID to kill (in column 1)
2. Do an
onmode -z sessionID
to kill the session.
3. To kill everyone connected to a single database:
for i in `onstat -g sql | grep databasename | awk '{print $1}'`
do
onmode -z $idone
(This can probably be done more elegantly, but it is 7AM for me, this is the
best you're gonna get at this time of the morning...it also hasn't been
tested!! :-)
--
"I'll Be Back"
Obnoxio
************************************************
Sane? Hell, if I was sane, why would I be here?
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com