RE: who are currently accessing my table?

Thanks Cliff, but that isnt the answer too (Why does it sound like a "guess the answer" show?) onstat -k gives you the currently locked tables. Well, you can tell me thata select statement share-locks my table, but a session doing a simple select doesnt place an entry with the tblsnum of my table in "onstat -k" output (try it). So, I cant find the session by looking at the locks.. another idea? > -----Mensaje original----- > De: Cliff Burton [SMTP:cburton@bigpond.net.au] > Enviado el: Viernes 17 de Noviembre de 2000 10:05 PM > Para: ckobashi@luzdelsur.com.pe > Asunto: Re: who are currently accessing my table? > > Carlos, > > You need to look at the locks! > > Bare with me this is from memory, as I am at home... > > I'd like to go into detail for you but I'll have to just > point you in the right direction as my memory isn't what > it was. > > onstat -k will list all of the locks, you can from the> report identify what is actually locked and how. > > This is the quickest and simplest of all methods, all you need to > do is identify your table. > > Good Luck > Cliff. > ----- Original Message ----- > From: <ckobashi@luzdelsur.com.pe> > Newsgroups: comp.databases.informix > Sent: Saturday, November 18, 2000 11:40 AM > Subject: Re: who are currently accessing my table? > > > > Steve, this isnt so simple as you think. > > "onstat -g ses" (or -g sql) gives you the current query, but my table > > may have been opened within a transaction. > > I've tried that, searching every session in my server and I couldnt > > find the specific one, even when there were many threads connected to > > my table. > > That isnt the answer. > > > > In article <LeiR5.256846$3E6.2805316@news1.alsv1.occa.home.com>, > > "Steve Waggoner" <steve.dot.waggoner@integtech.dot.com> wrote: > > > onstat -g ses> > > > > > "Carlos Kobashikawa C." <ckobashi@luzdelsur.com.pe> wrote in message > > > news:8v48t0$8mt$1@news.xmission.com... > > > > > > > > How can I know who are currently accessing a table?. > > > > I need to create an index or alter it but I cant because I dont have > > > > exclusive access. I know how many threads are connected, by using > > > onstat -t,> > > > but I want to know which sessions they are. (my users dont close the > > > > applications at nigth) > > > > > > > > Thanks in advance > > > > > > > > Carlos > > > > > > > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. >