Welcome Guest. Sign in or Signup

2 Answers

Interview » Technical » Data Mover » Restarting a failed DMS

Restarting a failed DMS

Asked by: 3645 views Data Mover

You have a huge DMS Import being executed. The script fails towards the end of the file. You have corrected the error and is ready to run the DMS again. How would you restart the execution from the point where it had failed?

Related Questions

2 Answers



  1. candidate on May 12, 2012 Reply

    We can use SET START AFTER to achieve this. The Data Mover will search for the RECORD_NAME within the .DAT file and start the import from the record after RECORD_NAME.

    +2 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. srivasthav on Aug 04, 2015 Reply

    Add the two parameters SET START and DROP TABLE above the IMPORT*
    and run the failed job automatically it will drop the table and create the table
    SET START ;
    DROP TABLE ;
    IMPORT*

    +1 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question