Archives of the TeradataForum
Message Posted: Wed, 11 Jun 2003 @ 21:33:27 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|