Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Dropped logtable
From:   Fred Pluebell

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020