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