Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2003 @ 15:49:39 GMT


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


Subj:   Fastload, Fastexport or Bteq export speeds
 
From:   Doorey, Andrew ST

We keep having intermittent problems transferring data to a SAS server from teradata using fastload mode in SAS. Occasionally it can take up to a day to transfer a small table of a few Mb. If we kill it and then run it again it will take a couple of seconds.

I just tried something similar using bteq export on my PC with a 150Mb table. The first time I ran it it took a few minutes to transfer. The second time I tried is still running now, 30 minutes later.

Someone here said that they think that there is a feature of fastload, bteq, etc. where data is transferred at whatever speed the transfer started at. Therefore if a few exports are started within a short space of time the last one will initially get very little bandwidth and the whole data transfer for this query will run at the same speed it started at, even after the other exports have completed and more bandwidth is available.

Can anyone confirm this and if possible point me in the direction of some documentation on it?


Thanks,

Andy Doorey.



     
  <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