Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Jun 2003 @ 21:33:27 GMT


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


Subj:   RDBMS failure, 2583: Worktable is missing ERROR in MLOAD
 
From:   Venkat

Hi,

Initially my mload job failed...then dropped all the temporary tables (TB_NAME_WORK, TB_NAME_ET, TB_NAME_UV and TB_NAME_LOG)...

Then i restarted my mload job.....

Now i am getting following error

**** 17:20:41 UTY0805 RDBMS failure, 2583: Worktable is missing for ABC.TB_NAME during MLoad restart.

I am trying to release lock release mload.. i am getting following error....

release mload  ABC.TB_NAME;
 *** Failure 2572 MLoad table TB_NAME can not be released.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.

How to resolve this?

My database is V2R5.

I done this before in V2R4, when we drop mload wrok tables and release mload is used to release the lock.....

I am wondering why this is not working in V2R5...

I appreciate your comments/suggestion?

Thanks in Advance



     
  <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