check to see if you have the switch on
issuing get monitor switches
if not, as it seems to be, set it up issuing "update monitor switches using
lock on"
you're going to be able to see it now, for your connection.


----- Original Message -----
From: "Parthasarathy [Partha] "
<db2udbdba-ezmlmshield-x11419272.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 27, 2004 9:39 PM
Subject: [Spam] 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]
>
>
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Scan engine: VirusScan / Atualizado em 26/05/2004 / Versão: 1.5.2
> Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/
>
> E-mail classificado pelo Identificador de Spam Inteligente Terra.
> Para alterar a categoria classificada, visite
>
http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=sao107642&_l=1085704791.705445.14338.pamplona.terra.com.br
>
>



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