Archives of the TeradataForum
Message Posted: Fri, 31 May 2002 @ 18:33:05 GMT
Subj: | | Re: Locks on table |
|
From: | | Raghav Vaidya |
There are 2 major phase that MLOAD can abend and the table can be released using different formats of the RELEASE MLOAD command.
If the job abends in the acquisition phase, a simple RELEASE MLOAD will do
If the job abends in the application phase, you need to use RELEASE MLOAD....., IN APPLY;
In the later versions, the situations under which tables need to be dropped during a MLOAD phase are very rare.
|