MLOADXUtilityLimits - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Determines whether MultiLoad Extended Protocol (MLOADX) concurrent task and AWT limits are specific to MLOADX jobs or are shared with other load utilities (FastLoad, MultiLoad, and FastExport).

Field Group

General

Valid Settings

Setting Effect
TRUE MLOADX concurrent task and AWT limits are determined by the values of DBS Control fields MaxMLOADXTasks and MaxMLOADXAWT, instead of by the values of MaxLoadTasks and MaxLoadAWT.
FALSE MLOADX shares the concurrent task and AWT limits of FastLoad, MultiLoad, and FastExport, which are determined by the values of DBS Control fields MaxLoadTasks and MaxLoadAWT.

Default

FALSE

Changes Take Effect

After the DBS Control record has been written.

Usage Notes

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

Related Topics

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.