MaxLoadTasks - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Specifies the combined number of FastLoad, MultiLoad, and FastExport tasks (jobs) that are allowed to run concurrently on Vantage.

This field is ignored if the throttles category set in the Teradata Viewpoint Workload Designer portlet is enabled.

Field Group

General

Default

5 tasks

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

If MaxLoadTasks is set to 0, no load utilities can be started.

The MaxLoadTasks field works together with the MaxLoadAWT field to limit the number of concurrent load utilities allowed to run:
  • If MaxLoadAWT is zero (the default):
    • MaxLoadTasks can be an integer from zero through 15.
    • The MaxLoadTasks field specifies the maximum number of combined FastLoad, MultiLoad, and FastExport jobs that can run concurrently.
    • The system does not consider the number of available AWTs when limiting the number of load utilities that can run concurrently.
  • If MaxLoadAWT is greater than zero:
    • MaxLoadTasks is an integer from zero through 30.
    • The MaxLoadTasks field sets the maximum number of combined FastLoad and MultiLoad jobs that can run concurrently. MaxLoadTasks does not directly limit the number of FastExport jobs that can run.
    • The number of combined FastLoad and MultiLoad jobs that can run concurrently is limited by the values of both the MaxLoadTasks field and the MaxLoadAWT field. When either limit is met, no further FastLoad or MultiLoad jobs are allowed to start until the limiting factor is reduced.
    • The maximum number of load utility jobs of any type—FastLoad, MultiLoad, or FastExport—that can run concurrently is 60. Consequently, the number of FastExport jobs allowed to run at any time is 60 minus the number of combined FastLoad and MultiLoad jobs that are running.

      For example, if the sum of currently running FastLoad and MultiLoad jobs is 29, the number of FastExport jobs that can be started is 31 (60 minus 29), regardless of the MaxLoadAWT and MaxLoadTasks settings.

    • If MaxLoadAWT is set to anything greater than zero, it can only be reset to zero if MaxLoadTasks is 15 or less.

About AWTs

AMP Worker Tasks (AWTs) are processes dedicated to servicing the Vantage work requests. A fixed number of AWTs are pre-allocated during Teradata system initialization for each AMP vproc. Each AWT looks for a work request to arrive in the Teradata system, services the request, and then looks for another. An AWT can process requests of any work type.

The number of AWTs required by FastLoad and MultiLoad changes as their jobs run. More AWTs are required in the early phases of the jobs than in the later phases. Vantage dynamically calculates the total AWTs required by active jobs, and allows more jobs to start as AWTs become available. If MaxLoadAWT is greater than zero, new FastLoad and MultiLoad jobs are rejected when the MaxLoadAWT limit is reached, regardless of the MaxLoadTasks setting. Therefore, FastLoad and MultiLoad jobs may be rejected before MaxLoadTasks limit is reached.

For example, FastLoad and MultiLoad require different numbers of AWTs at different phases of execution. The following table shows how many AWTs are used at each phase.

Load Utility and Phase Number of AWTs Required
FastLoad: Loading 3
FastLoad: End Loading 1
MultiLoad: Acquisition 2
MultiLoad: Application 1 per target table
Assume that MaxLoadAWT = 48 and MaxLoadTasks = 30. The list below shows some permitted combinations of load utility jobs. The limiting conditions for each combination is shown in bold:
  • 16 FastLoads in Loading phase

         16 concurrent load tasks

         48 AWTs in use: (16 x 3)

  • 9 FastLoads in Loading phase and 21 FastLoads in End Loading phase

         30 concurrent load tasks

         48 AWTs in use: (9 x 3) + (21 x 1)

  • 24 MultiLoads in Acquisition phase

         24 concurrent load tasks

         48 AWTs in use: 24 x 2

  • 5 MultiLoads in Acquisition phase and 25 MultiLoads in Application phase

         30 concurrent load tasks

         35 AWTs in use: (5 X 2) + (25 x 1)

  • 6 FastLoads in Loading phase and 15 MultiLoads in Acquisition phase

         21 concurrent load tasks

         48 AWTs in use: (6 x 3) + (15 x 2)

Related Information

For more information on... See...
Load utilities (MultiLoad, FastLoad, FastExport, and Teradata Parallel Transporter)
  • Teradata® MultiLoad Reference, B035-2409.
  • Teradata® FastLoad Reference, B035-2411.
  • Teradata® FastExport Reference, B035-2410.
  • Teradata® Parallel Transporter User Guide, B035-2445.