Rogue user session
- From: "Nog" <noel@xxxxxxxxx>
- Date: 19 Jan 2007 03:42:14 -0800
Hi,
Informix Dynamic Server Version 7.31.UD7, solaris 8
I've got a rogue user session connected to my instance that I need to
remove, if possible without bouncing the engine.
snippet frm onstat -u
4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0
0
4ef1d618 T--P--- 32908171 userxyz console 539f5f5c 0 0 0
0
512f3318 T--P--- 32902685 userxyz console 539f5f5c 0 0 0
0
539c9818 Y--P--- 32885158 userxyz 29 52ccd890 0 3 202
129
basically, the user was running an SQL script to setup a database, the
script hung, so he killed (-9?) the process, this left the session
32885158, an onmode -z generated the session 32885750, trying it again
just created another session and an onmode -Z created another.
What can I do, short of bouncing the engine, to clear these sessions.
thanks
.
- Follow-Ups:
- Re: Rogue user session
- From: RoB
- Re: Rogue user session
- Prev by Date: Software Testing Articles
- Next by Date: Re: Rogue user session
- Previous by thread: Software Testing Articles
- Next by thread: Re: Rogue user session
- Index(es):