Archives of the TeradataForum
Message Posted: Tue, 27 May 2003 @ 12:55:37 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|