SELECT s.username tutan_kullanici, s.sid tutan_session, t.username bekleyen_kullanici, t.sid bekleyen_session, l.type locktype, l.dbsname veritabani, l.tabname tablo, l.rowidlk tutulan_rowid FROM sysmaster:syslocks l INNER JOIN sysmaster:syssessions s ON s.sid = l.owner LEFT JOIN sysmaster:syssessions t ON l.waiter = t.sid WHERE l.dbsname <> 'sysmaster' and l.tabname <> 'sysdatabases' ORDER BY veritabani, l.tabname;
Devamını Oku »Informix lock user sesion list
