Archives of the TeradataForum

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

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

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>>