Archives of the TeradataForum

Message Posted: Fri, 19 Jun 2009 @ 11:46:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

As a user without Teradata Manager/PMon etc. there is one way that you can kinda check if there is a lock on a table. If you run the SQL below the query will run if you can get the read lock but it will fail if you can't get the lock.

     Locking Table   dbName.myTable  for Read nowait
     Select * from  dbName.myTable  ;

It's not that great really as you can't tell who put the lock there only you can or can't get an access/read/write/exclusive lock on a table. But it's the best that you can do with either SQL Assistant or BTEQ.

Thanks,

Fachtna

Fachtna O'Donovan
Enterprise Data Warehouse,
AIB Bank
Ireland

	<Prev	Next>		<<First	<Prev	Next>	Last>>