16.10 - Limits on Update Jobs - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The Update operator requires one Teradata Database load slot when the job uses the traditional MultiLoad protocol.

The number of concurrent load slots is, however, configurable in the Teradata Database environment using the same MaxLoadTasks field control used by FastLoad, FastExport, and MultiLoad. For example, one Teradata PT Update job equates to one MultiLoad .IMPORT step in a MultiLoad job in the count for MaxLoadTasks.

When the job uses the extended MultiLoad protocol, the Update operator requires one Teradata Database load slot if the configurable Teradata Database control field, MLOADXUtilityLimits, is set to FALSE.

If MLOADXUtilityLimits is set to TRUE, the Update operator requires one Teradata Database extended MultiLoad protocol slot when the job uses the extended MultiLoad protocol.

The number of concurrent extended MultiLoad protocol slots is, however, configurable in the Teradata Database environment using the MaxMLOADXTasks field control. The number of concurrent extended MultiLoad protocol slots counts when the MLOADXUtilityLimits field control is set to TRUE.

Sample scenarios include:

  • Scenario #1: Assume the MaxLoadTasks field control is set to 15 and the MLOADXUtilityLimits field control is set to FALSE. Teradata Database will allow a maximum of 15 concurrent jobs that use the FastLoad, FastExport, traditional MultiLoad, and extended MultiLoad protocols.
    The value for the MaxMLOADXTasks field control is ignored, because the MLOADXUtilityLimits field control is set to FALSE.
  • Scenario #2: Assume the MaxLoadTasks field control is set to 15, the MLOADXUtilityLimits field control is set to TRUE, and the MaxMLOADXTasks field control is set to 60. The Teradata Database will allow a maximum of 15 concurrent jobs that use the FastLoad, FastExport, and traditional MultiLoad protocols, and the Teradata Database will allow a maximum of 60 concurrent jobs that use the extended MultiLoad protocol.

For more information, see “DBS Control Utilities” in Utilities (B035-1102).