Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Nov 2001 @ 14:54:58 GMT


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


Subj:   Handling Mload failures
 
From:   Ruth Fenwick

I have some questions on how best to handle a bad mload....

We had an MLOAD come in the wrong input dataset (5 days worth of load instead of one). The application team cancelled the job through MVS and then dropped all the error tables and then tried to release the mload lock. They couldn't, so I suspect that the load was in the application phase already.

Questions:

1) Did I have any options besides a restore and reply 4 days worth of loads?

2) The table has a NUPI, but based on tests I just ran, it would have rejected all the duplicates. Does this make sense?

3) Could I have just re-created the error tables and restarted?

4) Is there a way to restore the table without the secondary indexes (just to speed things up). I'm not referring to the nobuild option on the restore, but dropping the indexes?


Ruth



     
  <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