CODEWITHSUNDEEP
sqllockingteradata
AFHood
AFHood

Reputation: 1040

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

Is there a way to know if a table is locked and what kind of lock is currently on a table? I was hoping for something through the DBC tables in teradata, but I can't find any reference to anything like this. I have normal user access and the DBA is no help. Thanks.

Upvotes: 2

Views: 25966

Answers (1)

mechanical_meat
mechanical_meat

Reputation: 169314

AFAIK only DBA utilities are available to determine the type of lock on a table.

With only user-level rights you can do something like the following (from here): 

Lock Table dbName.myTable for Access nowait
Select * from dbName.myTable;

And according to the master himself (Geoffrey Rommel):

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

Upvotes: 2

Related Questions