Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Aug 2013 @ 23:44:50 GMT


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


Subj:   Slow Loads from DataStage
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, August 07, 2013 17:10 -->

Hi all,

I am hoping somebody can give me some insight into why we seem to have what I think are extremely slow Fastloads coming through our DataStage server. We are currently migrating data from DB2 to Teradata and running 3-5 table loads in parallel, with between 1.5 and 3.7 billion rows. 2 tables are over 3,5 billion rows and look like they will take over 45 hours to run, based on progress after 24 hours. I have asked the team to supply the scripts so that we can try and see if there is any tuning we ca do, but they advise they don't have any scripts as they just and drag and drop the tables in a GUI. There is virtually no skew in the tables and we have TASM enabled which sets 36 sessions for every Fastload job.


Any thoughts!



     
  <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