Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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 !


Thanks

Sreedhar



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