Table lock

Database
N/A

Table lock

How to find if a table is locked by a user or session?
6 REPLIES
N/A

Re: Table lock

Hi Sakthi,
no way to find that out using SQL.

There's only a command line tool called LokDisp...

Dieter
N/A

Re: Table lock

Hi Dieter,

Is there a document or help file for using Lokdisp tool? Am sorry if am asking you too many things at a time:-)
N/A

Re: Table lock

hi Sakthi,
check the site Info.ncr.com
doc: Database Administrator
N/A

Re: Table lock

Hi Gokul,

I went through the site, but couldnt find the doc which you have specified. I only found data administration doc. Let me knw if that is the right one.
N/A

Re: Table lock

hi,
yep the same document....but not detaily...
you can check the doc Teradata utilities doc..rather than.....teradata administrator...

Re: Table lock

you can type

start lokdisp

in your supervisor window and it will show up with a small help menu ...

you can get further help on topics by giving the topic as argument to the help command.

ie like

HELP TRAN

That would give you a quick start.
....