All Forums Tools
chill3che 99 posts Joined 10/12
15 Mar 2013
Fast load Vs Mload when AMP is down

Hello Experts,
No AMPs may go down (i.e., go offline) while fastload is processing,  where as Multiload can work based on the value set through the parameter AMPCHECK.  How is this achieved.  What kind of processing is done by the load utilities in this case.
Assuming the both fallback and non-fallback tables in this scenario, can you please explain this them relative to fast load and Mload.  Thank you for your time on this.

Thanks, Cheeli
dnoeth 4628 posts Joined 11/04
17 Mar 2013

Hi Cheeli,
FastLoad directly loads into the target table and is simply not implemented to handle down AMPs.
MLoad uses worktables which are always Fallback protected, when an AMP is offline there's still the Fallback copy of the row to work with. And if the target table is also Fallback there's TD's "Down AMP Recovery Journal" to deal with it.
But when an AMP is down (data loss in a RAID?) you usually have more urgent things to do than running a load job :-)
Dieter
 
 

Dieter

chill3che 99 posts Joined 10/12
19 Mar 2013

Thank you Dieter for your time on this.

Thanks,
Cheeli

a2kz 16 posts Joined 05/13
28 Aug 2014

what if the target table is created with no fallback option ?

dnoeth 4628 posts Joined 11/04
29 Aug 2014

A table without Fallback is destroyed when an AMP looses data.

Dieter

You must sign in to leave a comment.