Multiload restartability

dsdeveloper13 · Post by **dsdeveloper13** » Mon Feb 09, 2009 2:35 pm

Hi,

I have a parallel job in 7.5.1A, that is loading into a Teradata table using a MultiLoad stage. if the job aborts in the middle of loading the data, can this be rerun in such a way that the multiload step picks up where it left off? I am currently having to delete the work tables before re-submitting the job.

Thanks.

richdhan · Post by **richdhan** » Tue Feb 10, 2009 2:47 am

Hi,

Check the Teradata multiload report file which you would have specified in the Teradata Multiload stage. There will be 5 phases of operation. Based on the phase of operation multiload might lock your table.

You also would have mentioned the log table, Work table and Error table.

Yes, you would have to drop all these tables.

Issue the below command
RELEASE MLOAD <table_name>
because multiload might have locked your table

Again re-run the job. If the job fails

1. Check the report file
2. Drop the tables
3. Issue the release command and re-run again

HTH
--Rich

dsdeveloper13 · Post by **dsdeveloper13** » Tue Feb 10, 2009 8:32 am

Thanks for your reply.
This solves the problem for doing a re-run if the multiload had stopped in Acquisition phase. What if the load is in Apply phase? Multiload cannot be re-run. Is that correct?
Is there a way to re-start the mload where it might have left off? Say for example, using the Unix file instead of the named pipe?

Thanks.