Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 01 Dec 2012 @ 09:11:23 GMT


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


Subj:   Re: Ideal TPUMP Sessions
 
From:   Dieter Noeth

Roopalini Bakthavachalam wrote:

  Thanks for the response. I ran tests with various combinations of PACK and SESSION factor. I noticed that having SESSION = 20 / SESSION =40 didn't make any difference. Below are the results I got for 1.1 Million records.  


  PACK = 20 and SESSION = 2 - It took 2.5 hours PACK = 20 and SESSION = 20 - It took 17 minutes  


Enable ARRAYSUPPORT and increase the PACK as high as possible, but when using multple sessions you probably need to switch on SERIALIE, too. You should get much higher throughput with less sessions.


Dieter



     
  <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