How to know if a table is locked is teradata?

Tools

How to know if a table is locked is teradata?

Which system tables do we need to look into? I am sure the type of locks applied to any table would be stored in some system tables. Correct me if I am wrong.
1 REPLY
Enthusiast

Re: How to know if a table is locked is teradata?

if you are looking for locks placed by normal SQL operations, then you need to use the LOKDISP utility.

for HUT locks, it's SHOWLOCKS