Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 May 2003 @ 12:55:37 GMT


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


Subj:   Re: How can I remove locks?
 
From:   Raghav Vaidya

Before you release any locks, it may be worthwhile to figure out why the locks were not released automatically. I am not familiar with ETL Datastage, but it seems to be a ETL tool (the name says it).

There are different ways locks can be released depending upon how the table was loaded, but it is imperative you have to look at why the locks were not automatically released. This could mean errors.

A very generic statement would be 'Release lock dbname.tblname'. If you can give me some more information about the load, I may be able to help you with a more specific release statement.

Raghav



     
  <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: 27 Dec 2016