Re: Who locks my table? Help!
OR EVEN BETTER
select s.username from syslocks l, syssessions s
where l.tabname = {TABLE NAME}
and l.owner = s.sid;consider using set isolation to dirty read for ordinary select statements in
u'r applications.
Cheers
Paul Watson wrote in message <356C3AB8.425060A0@mcmail.com>...
>Wolf P'ter wrote:
>
>> How can I query which user lock the whole table?
>> Any orher people get -247, -113 when tying to update!
>>
>> I ve tried to look in the sysmaster:syslocks table, but I can't
>> understand it.
>>
>> Thanks any help
>> Peter Wolf
>
> select dbsname database, username, hostname, tabname table, type
> from syslocks, syssessions
> where sid = owner;
>
>should get you started.
>
>--
>Paul Watson #
>WF Software Ltd # If it ain't broke,
>Tel: +44 1436 674729 # fix it till it is.
>Fax: +44 1436 678693 #
>www.wfsoftware.co.uk #
>
>