If you are at version 8, you can do a get snapshot for locks on database.
Remember that if you do that command on the dos command prompt
autocommit is on, so it did the lock and since the command finished its
gone. If you want to see what it looks like go into the command center
and turn autocommit off and then do the lock exclusive and then do a
snapshot.

There is also a lock event trace.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Parthasarathy
\[Partha\] "
<db2udbdba-ezmlms To
hield-x11419272.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

05/27/2004 08:39 Subject
PM Can anybody pls tell me how to find
who has locked my table.










Hi,
Can anybody pls tell me how to find the locks on a table. I
tried to look at the snapshots [locks and all]. But I could not
see.
I gave the command explicitly 'Lock table xxx in exclusive mode'
and could not locate who has locked and which object.
Thanks
Parthahs




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



DB2 & UDB email list listserv db2-l LazyDBA home page