Archives of the TeradataForum

Message Posted: Fri, 05 Dec 2003 @ 12:25:16 GMT

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

Hey Craig

I use Teradata Manager and Remote Console to run the show locks utility. This will bring up any host utility locks and also inform you of the session and the user...

You can then use straight SQL to do a release lock...

In SQL Assistant:

Release Lock database.table, override;

This will release the locks on all the amps for the table. I have not found a way to discover locks via SQL at this time... This appears to be a utility thing...

Chris Coffing
Senior Vice President
Coffing Data Warehousing
www.coffingdw.com

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