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