Lock Info in teradata

Analytics
Enthusiast

Lock Info in teradata

Hi all,

Is there any SQL with help of which we can get the information as which table and what kind of lock is acquired on it at any point of time in teradata.

Your response will be appreciated.

Thanks
1 REPLY
Enthusiast

Re: Lock Info in teradata

The Lock Display utility provides a snapshot capture of all real-time database locks.
Also we can take the help of PMON