Who’s locking my datas?

who has locks on an informix table:


A variation on the SQL is this: select trim(s.username)||”:”||s.sid||” has “||trim(l.type)|| ” lock on “||trim(l.dbsname)||”:”||trim(l.tabname)||”-“||hex(l.rowidlk) L from sysmaster:syslocks l, sysmaster:syssessions s where s.sid = l.owner — and dbsname <> ‘sysmaster’ order by 1 ; Note: The select portion of the query must be entered all on one […]