Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 16:24:49 GMT

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

Subj:   Re: Drop tera table
From:   Frank O Connor


I believe that Fred is correct. The mload log table is used for the restartability of mload. One of the advantages of multiload is that it does not have the overhead of using the transient journal. And thank God for that as rollbacks do not take place if the mload fails.

If it fails, the table can be left in an unusable state and this means that you have a choice.

1. Either restore the table from archive and start again

2. Restart the mload (perhaps it failed due to lack of space).

You will not be able to restart if the logtable does not exist.

Hope this is a help.



  <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: 28 Jun 2020