Re: Indice locking
Shamelessly ripped off
brett
-- lockwaits.sql
database sysmaster;
select dbsname,
b.tabname,
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,
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;
select dbsname,
tabname,
type[1,4],
owner,
ownername ,
waitname
from A;
Tony Woods wrote:
>
> Hello all,
>
> The way we find whose locking what table, is there a way to find whose
> locking(shared/exclusive....) the indices(page/row/key).
>
> Thanks a lot in advance for all your replies.
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
--
-----------------------------------------------------------------
Brett's 11th law of UNIX administration...
Users think that Y2K was a non-event... well... They havn't got
our overtime bills yet :)
-----------------------------------------------------------------
Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings.
Tel. +27 31 717 4000 Direct. +27 31 717 4146
Fax. +27 31 717 4001
-----------------------------------------------------------------
The little voices are talking to me again, telling me to reach
for a keyboard and type rm -rf /*
last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'`
now I fear I have no answers
-----------------------------------------------------------------