Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 01 Oct 2001 @ 16:34:17 GMT


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


Subj:   Re: Multiload status
 
From:   Thomas F. Stanek

Ruth,

This may sound like it's coming out of left field, but is the SQL in the MLOAD properly tuned? If I'm understanding your stats correctly, the MLOAD is consuming over 16 Million CPU seconds to load about 112 Million rows. I don't know much about your data model, etc., but that seems like a tremendous amount of CPU power to process that many rows. Is it possible that the target table is a VERY non- unique NUPI, the table is a SET table, and the rows are very long? Does this process use this much CPU when there are no NUSI indices?

BTW, where did you get these stats? DBC.AMPUSAGE?


Regards,

Thomas F. Stanek
TFS Consulting



     
  <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