Re: how to know who has locked particular table ?

Posted in 1999

Jorge Puente Beltran — Tue, 11 May 1999 18:55:56 +0200 — source: Informix-list mailing list archive (1991-1998)

I'm using this query... database sysmaster; select a.sid,a.username, a.tty, b.tabname, b.type from syssessions a, syslocks b where a.sid=b.owner and b.dbsname IN ("your_database") order by 4 try it... Jorge Puente Garnadi wrote: > I'd like to know who has locked particular table. > What should I do ? > > -- gnd