who has locks on an informix table:
http://www-01.ibm.com/support/docview.wss?uid=swg21226344
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 […]
Recent Comments