RE: orphaned lock process
????
So when you run something like this:
set isolation dirty read;
Database sysmaster;
select dbsname,
b.tabname[1,18],
rowidr,
keynum,
e.txt type,
d.sid owner,
g.username ownername,
f.sid waiter,
h.username waitname
from syslcktab a,
systabnames b,
systxptab c,
sysrstcb d,
sysscblst g,
flags_text e,
outer ( sysrstcb f , sysscblst h )
where a.partnum = b.partnum
and a.owner = c.address
and c.owner = d.address
and a.wtlist = f.address
and d.sid = g.sid
and e.tabname = 'syslcktab'
and e.flags = a.type
and f.sid = h.sid
into temp A;
-- Some fields are commented out to fit on an 80 column display
select dbsname[1,8],
tabname[1,18],
rowidr,
-- keynum,
type[1,4]
--owner,
--ownername
-- waiter,
-- waitname
from A
where dbsname[1,3] <> "sys"
and tabname[1,3] <> "TBL"
and tabname[1,3] <> "sys"
order by tabname ;
drop table A;
What do you see????
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of tomcaml@yahoo.com
Sent: Tuesday, March 22, 2005 8:57 AM
To: informix-list@iiug.org
Subject: orphaned lock process
hello all,
i have the situation where a lock is left on a table but there is no
session id associated with it. is there a way to kill this orphaned
lock?
thanks!
sending to informix-list