Archives of the TeradataForum
Message Posted: Wed, 02 Apr 2008 @ 13:05:46 GMT
In Teradata Database V2R6.1 and above, the maximum number of concurrent load jobs is restricted up to 30 concurrent FastLoad and/or MultiLoad jobs.
This limitation is 60 for FastExport (minus the number of active FastLoad and MultiLoad jobs). The default value is 15 for MaxLoadTasks. You can set this max 30 if you want. Please check DBS Control Utility.
Your error message "Too many load/unload " must have come because of this only.
# Parameter Description Range 1 MaxLoadAWT* Determines no. of AWT's 0 - 48 (AMP Worker Tasks) available to load utilities 2 MaxLoadTasks Determines the limit for 0 - 30 concurrent loading utilities * This will be enabled only MaxLoadAWT > 0 otherwise MaxLoadTasks will be used
Maximum possible loading utilities at a time
So for example MaxLoadAWT = 48 and MaxLoadTasks = 30, possible job mixes* include:
16 FastLoad jobs in Phase 1(Acquisition)
9 FastLoad jobs in Phase 1(Acquisition) + 21 FastLoad jobs in Phase 2(Application)
24 MultiLoad jobs in Acquisition Phase
5 MultiLoad jobs in Acquisition Phase + 25 MultiLoad jobs in Application Phase
Utility # of AWTs needed FastLoad Phase 1 (Acquisition) 3 FastLoad Phase 2 (Sort) 1 MultiLoad Acquisition Phase 2 MultiLoad Application Phase 1 FastExport All phases 0* * This includes failed jobs in unreleased state
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|