Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Oct 2001 @ 20:03:30 GMT


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


Subj:   Re: Multiload status
 
From:   Ruth Fenwick

Just as an FYI dropping the 3 NUSI's on the table changed the load time from 24+ hours to 1 hour for 112 million rows. Rowlength is 32 bytes with a UPI. This may be a dumb question, but do standard MVS tuning techniques help - like putting some buffering on the input file? I think it's spending most of the hour in the acquisition phase.

Ruth Fenwick
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company



     
  <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