Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2008 @ 14:18:43 GMT


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


Subj:   Re: Reduce loading time
 
From:   Anomy Anom

<-- Anonymously Posted: Wed, 6 Feb 2008 08:08 -->

Are you getting any rows in the error tables? That slows down throughput dramatically.

Do you have lots of NUSIs on these tables?

Have you checked for lock contention (blocking), e.g. using PMON while batch is running?

Have you checked ResUsage for CPU, memory, etc. utilization?

Is the bulk of the MLOAD time being spent in the Acquisition phase or the Apply phase?



     
  <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: 23 Jun 2019