Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Mload lock release automation
From:   Sreedhar Kavali

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 !



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020