Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Nov 2002 @ 10:23:57 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Abends on Multiload and Recovery
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 26, 2002 23:53 -->


We have a situation where Multiload is being used to load 500MB of data in a short time window. We face two problems:

1. In some trials MLoad crashed in the middle of the "application" phase, and recovery was very problematic. Has anyone faced similar problems? What are the options available to us?

2. As MLoad does table-level locking, the table is not accessible for a long period. Are there any ways around this problem?

While TPump is being used to load currently, the time taken is much larger than the load window available, and multiload seems to be the only option.

The load platform is NT.

Would really appreciate any pointers to proceed further.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020