Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Apr 2003 @ 14:18:42 GMT


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


Subj:   Re: Improving performance of Bteq Export
 
From:   Geoffrey Rommel

  > What are the keys to get the cli via bteq to export data from Teradata as quickly as possible?  


  Not really having done much testing with this you could try changing the "response buffer" size in the clispb.dat (rsplen=8192 is the default ; can be set to 64K).  



There is also an option called "parallel CLI". I've never used it, but perhaps someone else could say whether it would be useful.



     
  <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: 15 Jun 2023