Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Sep 2001 @ 19:57:09 GMT


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


Subj:   Re: Multiload performance
 
From:   David Wellman

Ruth,

One option which may help you is to only drop/create some of the nusi's. The nusi too drop is the one which is most non-unique. This is the nusi that will hit multiload performance the worst, so dropping/creating this one will give you the most "bang for the buck". I've seen this approach taken a couple of times and gets the best of both worlds. BTW is there any mileage in upping the priority of the multiload jobs?

Is using tpump an option for you? This won't load the data as quick as Multiload, but tpump gets affected by nusi's a lot less and may allow you to load data during the online day - it has less impact on other processing. If doing this you can also use priority scheduler to regulate impact of the tpump jobs.


Cheers,

Dave



     
  <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