The Update operator requires one database load slot when the job uses the traditional MultiLoad protocol.
The number of concurrent load slots is, however, configurable in the 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 database load slot if the configurable database control field, MLOADXUtilityLimits, is set to FALSE.
If MLOADXUtilityLimits is set to TRUE, the Update operator requires one 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 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.
- Scenario #1: Assume the MaxLoadTasks field control is set to 15 and the MLOADXUtilityLimits field control is set to FALSE. The 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 database will allow a maximum of 15 concurrent jobs that use the FastLoad, FastExport, and traditional MultiLoad protocols, and the database will allow a maximum of 60 concurrent jobs that use the Extended MultiLoad Protocol.
For more information, see “DBS Control Utilities” in Teradata Vantage™ - Database Utilities, B035-1102.