Archives of the TeradataForum
Message Posted: Thu, 04 Nov 1999 @ 15:21:24 GMT
If you were in ACQUIRE phase of MLOAD, it's simple. Use BTEQ: RELEASE MLOAD dbname.tablename; If you're not sure, you can always try it. This form of RELEASE MLOAD will give you an error message if you were not in the ACQUIRE phase.
In APPLY phase, it's more complicated. If the logtable was dropped in error but the worktable(s) and errortables are intact, you should be able to create a new (empty) logtable and restart the MLOAD with the OVERRIDE parameter (PARM='OVERRIDE' in MVS JCL; maybe -o switch in Unix/Windows).
Other alternatives, provided you have some way to validate data integrity and/or "scrub" the data afterward: Use BTEQ: RELEASE MLOAD dbname.tablename IN APPLY; (this is relatively new feature) or copy (INSERT/SELECT) or export data using LOCKING ... FOR ACCESS modifier
For everything except the "OVERRIDE" restart, you will need to manually DROP the worktable(s) and errortables after you're done. Good luck.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|