RE: Locked tables
You can find out who is holding the lock and
kill that particular session.
onmode -z kills sessions.
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, syssessions w
where
l.owner = s.sid and
l.waiter = w.sid
on the sysmaster database might give you some information about
what locks are being waited on.
Hope this helps...
Will
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------