RE: Who Access Tablename?
Posted in 2004
Topics: General Discussion
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3DBB1.EAD88AA0
Content-Type: text/plain;
charset="iso-8859-1"
Check who is processing sqls.
onstat -g sqland note the session ids
Check each of these sessions.
onstat -g ses ses_id
This will show the sql code being processed and the user_id.
-----Original Message-----
From: Xuanhai Carmichael [mailto:xcarmichael@puyallup.k12.wa.us]
Sent: Thursday, January 15, 2004 4:28 PM
To: informix-list@iiug.org
Subject: Who Access Tablename?
Is there any way to find out who is accessing a tablename in a
database? Thank you.
Xuanhai
sending to informix-list
------_=_NextPart_001_01C3DBB1.EAD88AA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: Who Access Tablename?</TITLE>
</HEAD>
<BODY>
<BR>
<P><FONT SIZE=3D2>Check who is processing sqls.</FONT>
<BR><FONT SIZE=3D2>onstat -g sql </FONT>
<BR><FONT SIZE=3D2>and note the session ids</FONT>
</P>
<P><FONT SIZE=3D2>Check each of these sessions.</FONT>
<BR><FONT SIZE=3D2>onstat -g ses ses_id</FONT>
</P>
<P><FONT SIZE=3D2>This will show the sql code being processed and the =
user_id.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Xuanhai Carmichael [<A =
HREF=3D"mailto:xcarmichael@puyallup.k12.wa.us">mailto:xcarmichael@puyall=
up.k12.wa.us</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, January 15, 2004 4:28 PM</FONT>
<BR><FONT SIZE=3D2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=3D2>Subject: Who Access Tablename?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2> Is there any way to find out who is accessing =
a tablename in a</FONT>
<BR><FONT SIZE=3D2>database? Thank you.</FONT>
<BR><FONT SIZE=3D2> Xuanhai</FONT>
<BR><FONT SIZE=3D2>sending to informix-list</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C3DBB1.EAD88AA0--
sending to informix-list
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g