Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2008 @ 13:05:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Anh-Tuan,

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)

OR

9 FastLoad jobs in Phase 1(Acquisition) + 21 FastLoad jobs in Phase 2(Application)

OR

24 MultiLoad jobs in Acquisition Phase

OR

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

Thanks!

Madhan M.
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>