Teradata locks - How to find if a table is locked?

Scenario: Is there a way to know if a table is locked and what kind of lock is currently on a table?

We can do something like the following:

\n\n

Lock Table dbName.myTable for Access nowait\nSelect * from dbName.myTable;\n

\n\n

If the table is locked, you will get\n error 7423, "Object already locked and\n NOWAIT. Transaction Aborted."
\n

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds