Archives of the TeradataForum

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

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

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>>