Re: How to find out which table is locked and kill the responsible process?
Try any of these queries :
SELECT
l.dbsname, l.tabname, l.rowidlk, l.type, s.sid, s.username,
s.hostname, l.waiter, w.username, w.hostname
FROM syslocks l, syssessions s, outer syssessions w
WHERE l.owner = s.sid AND l.waiter = w.sid;
select username, uid, waiter, dbsname, tabname, rowidlk, keynum, type
from sysmaster:syslocks, sysmaster:syssessions
where sysmaster:syssessions.sid=sysmaster:syslocks.owner and type='IX';
Vinod Bhansali
>From: "Mahmoud Kamoun" <kamounm@usgs.gov>
>Reply-To: "Mahmoud Kamoun" <kamounm@usgs.gov>
>To: informix-list@iiug.org
>Subject: How to find out which table is locked and kill the responsible
>process?
>Date: Fri, 2 Jun 2000 22:08:49 GMT
>
>I tried to dbexport a database but I got the following messages:
>
>
>-425 - Database is currently opened by another user.
> - 107 - ISAM error: record is locked.
>
>
>How can I find the tabid or the table name of the locked table and the
>process id that holds the lock? here I am thinking about the system
>catalog, the onstat -k does not give the name of the locked table.
>
>How can I kill the lock without shutting down informix ?
>
>Thanks.
>
>
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com