Archives of the TeradataForum

Message Posted: Sat, 03 Sep 2016 @ 09:43:34 GMT

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

Hi Experts,

I'm looking for a solution to release Mload lock automatically before re running the Informatica job after failure.

Currently I'm using Informatica TPT connection to load data into a Teradata table using Mload type.

I added one pre sql command before loading into a table, it works fine if the table has Mload lock. But the command fails if table is not in Mload Status "RELEASE Failed. 2580: MLoad not active on table"

     RELEASE MLOAD db_name.table_name IN APPLY

Trying to find the solution to ignore error message and execute Mload release command, so that the job does not fail even though the table is not in Mload status.

Any thoughts !

Thanks

Sreedhar

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