Re: CLIENT/SERVER CONECTIONS

get the user thread address for that user from the 'tbstat -u' output and pair it with the 'owner' column from the 'tbstat -k' output. for that owner in the 'tbstat -k' output get the corresponding 'tblsnum'. this num is in hex. then run the following command : echo "select tabname from systables where hex(partnum) = \\"<partnum>\\" | isql <database> that will give u the actual tablename having a lock on it. regards, bipin On Mar 19, 6:23pm, Javier Puente wrote: > Subject: CLIENT/SERVER CONECTIONS > Hi folks, I would like to know which users are accesing a DATABASE or > an especific table of this DATABASE. > > In general, when a user access a table from a client/server aplication, > this generates an entry for "tbstat -u", but how know which table the > conection refers to??? > I am using Informix Online 5.01 in SUN. > If somebody knows any form to do it, I will apreciate. > > Thanks in advance, > Javier Puente > Corporacion NOboa >-- End of excerpt from Javier Puente