Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Finding and removing locks
From:   Chris Coffing

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019