Archives of the TeradataForum
Message Posted: Sat, 22 Jan 2005 @ 16:07:28 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|