Archives of the TeradataForum

Message Posted: Thu, 04 Nov 1999 @ 15:21:24 GMT

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

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.

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