How to remove the table lock in teradata table

General

How to remove the table lock in teradata table

Hi,

 

I am not able to select, drop or delete any rows from a teradata table.

 

I think it is locked, can anyone please suggest a way in unlocking this table.

 

Thanks!

Tags (1)
3 REPLIES
rjg
N/A

Re: How to remove the table lock in teradata table

It could be locked or your query could be blocked.

Run showlocks t check for HUT locks. Run Release lock db.tb, override; to release

Use viewpoint to view blocking.

 

 

Rglass

Teradata Employee

Re: How to remove the table lock in teradata table

To confirm that you are being blocked, try a SELECT with an ACCESS LOCK:

 

Locking row for access select count(*) from  .......

 

If this works, then, yes, you are probably blocked.  Use Viewpoint to chase down the blocking lock

 

 

Re: How to remove the table lock in teradata table

Thanks! for the reply and solution.

Tags (1)