Locks in Teradata


Locks in Teradata

Hi Everyone,

We have a below scenario:

Everyday we have lot of jobs running (Multiload). Some of them are failing and some of the tables are getting locked.

How to find out all the tablenames, which are being locked?

Is there any SQL or script for knowing this?

Any suggestion on this is appreciated.



Re: Locks in Teradata

I think you can use sp_lock (and sp_lock2). And also When you are reading sp_lock information, use the OBJECT_NAME( ) function to get the name of a table from its ID numbers.  I hope it will help you to get some idea.