Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Sat, 22 Jan 2005 @ 16:07:28 GMT


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


Subj:   Re: Releasing MLoad lock during the Acquistion Phase
 
From:   Michael Larkins

Vishual:

If this is a production table you probably do not want to release the lock. Instead, the recommended procedure is to fix the cause of the abort and restart Mload so that it can finish successfully and release the lock itself.

The problem is that part of your inserts, updates or deletes have been completed but others have not. Your table is partially changed. If you terminate the Mload and release the lock, you cannot restart the job and your table can be lacking data integrity.

Just a thought,


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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: 28 Jun 2020