Lock Info

Database
Enthusiast

Lock Info

Hi,

Is there any SQL which wil fetch information like which table is lock, what kind of lock is there is on table and which user is locking the table.

I do ve DBA priviledge. I know this can be seen thru Teradata Manager but i am looking an SQL to find this info.

Please help with your expertise.
2 REPLIES
Junior Contributor

Re: Lock Info

The only way to see all locks is the Lock Display (lokdisp) command line utility.

If you want to know if a query is blocked you might use PMon or (in TD12) write some queries using the Open API UDFs in syslib.

Dieter
Enthusiast

Re: Lock Info

We can also use Locking Modifier with NO WAIT Option to check if lock exists or not ?