Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 16:36:17 GMT

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

Subj:   Re: User Queries holding out Batch
From:   John Hall

Glen Blood wrote

  "If the MLOAD dies in the APPLICATION phase. RELEASE MLOAD does not work. You then need to kill any USIs, perform a RELEAS MLOAD ... IN APPLY, recreate the USIs and recollect statistics."  

If your prior MLoad blew-up in apply, left a lock and you haven't resolved the problem with a successful completion, then the odds are that your target table has probably been corrupted. The only real solution at that point is to drop the table and see if your last archive was any good, restart the MLoad that didn't finish (I assume that you were doing it for a reason) and then start getting your excuses ready.

You might get lucky a few times, but then again, I know people who have lottery tickets as part of their retirement planning. Hmmm - if they get any win, then their planning was a lot better than those who bought Enron.

  <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