Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 14 Jun 2009 @ 09:16:05 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: MLOAD performance problem
From:   Vinay Bagare


Is it just for this one interface that you have problem?

Is it during specific time of the day you have problem with this interface (If no, then I would check the Informatica Mapping).

And yes, there will be write locks and it creates Log, error tables in a specific database as specified in your script (exclusive locks in this case).

I have seen dictionary contention for mostly poorly written TPUMP jobs.


Vinay Bagare

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