All Forums Tools
prakhar 101 posts Joined 05/08
14 Aug 2009
Fastload and Multiload

Hi,As we know Fastload doesnt allow duplicate rows in even Multiset table.So suppose i have a chechpoint of 10k and job failed at 9k those records upon restart will be send again and by virtue of this property ignored..or i can use RECORD keyword to skip those recordsNow my mload is having similar scenario and it failed in acquisition after 9k records.....what wud be the scenario after restart ......are all 9k records will be send there anyway to stop this...RELEASE MLOAD IN APPLY....what does this statement really does....and when shud we use it.....I have read it simply releases locks from table header and table while in application phase...Does it rollback also...?Quick response will be appreciated..Regards,

Raja_KT 1246 posts Joined 07/09
14 Aug 2009

Hi,Since it fails in acquistion phase, you dont need to worry. Also double check in target table that nothing is loaded.Just a check.Since it fails it acquisition phase you need to Dropping the restart log table, the work table, and theacquisition error table,release mload. You dont need to worry about your 9k or 10 k if it is in acquistion phase. Experts please add... Rgds, Raja

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

prakhar 101 posts Joined 05/08
14 Aug 2009

hi raj,thanx for reply,as we know mload is restartable from all 5 phases the solution given by you is a rerun not a restart.could u plz tell how we can restart in this scenario or is it not possible at all.

ANIMESH.DUTTA 35 posts Joined 05/09
21 Aug 2009

In Acquisation phase - suppose your checkpoint is 1k and your load fails at 9200 records.Those 200 records - it'll not insert at all.You can again restart the Mload by not deleting the Log/Error tables - releasing MLOAD.It'll start to load from 9001 record perfectly.In application phase - you need to use RELEASE MLOAD IN APPLY - to specify that it's in Application Phase and drop Error tables, Work table, Log table and then resubmit the script.

Animesh Dutta
Teradata Certified Master

You must sign in to leave a comment.