Archives of the TeradataForum
Message Posted: Mon, 05 May 2008 @ 16:29:35 GMT
| Subj: | | Re: Errors during mload |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Mon, 5 May 2008 10:17 -->
The output messages will tell you when MLOAD enters each phase. In general, you do NOT want to drop any of the tables - you want to fix the
problem and restart the job. MLOAD will pick up where it left off.
If you are determined to "start over", you may use "RELEASE MLOAD" in a BTEQ session followed by dropping the work, error, and log tables only
if the RELEASE is successful (acquisition phase) or says there was no lock to be released (before acquisition or after application).
In application phase, there is RELEASE MLOAD IN APPLY, but be sure to read all the cautions and restrictions in the manual. This should be used
only as a last resort - e.g. when you have no backup and must recover whatever inconsistent (partially updated) data remains in the table.
| 
