Load Utility Reserved Query Bands - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Load utility reserved query bands are used by Teradata load utilities.

Customer-written applications must not use these query band names. They are reserved for use by Teradata-written applications and applications written by third party Teradata partners.

Following are the load utility reserved query bands:

Query Band Description
DSAJobType Backup or restore.

Applies only to session query band.
UtilityAWT Number of AWTs required for current job.

Applies only to session query band.
UtilityDataSize Estimated size of data to load, unload, back up, or restore by utility component:
  • SMALL
  • MEDIUM
  • LARGE
UtilityName Name of calling load utility. Represents mechanism by which data is loaded, extracted, archived, or restored, by standalone utility (such as FastLoad) or embedded utility (such as JDBC FastLoad).

Reserved Query Band Load Utility Names

The following query band utility name values only work with load utilities and APIs that support the reserve load utility query band names. Do not use these reserved utility name values in your applications.

UtilityName Value Utility or API Supported
FASTEXP FastExport

For information about the CLIv2 version of the FastExport utility, see Teradata® FastExport Reference, B035-2410.
FASTLOAD FastLoad

For information about the CLIv2 version of the FastLoad utility, see Teradata® FastLoad Reference, B035-2411.
JDBCE JDBC FastExport

For information about using the embedded JDBC version of the FastExport utility, see ODBC Driver for Teradata® User Guide, B035-2526.
JDBCL JDBC FastLoad

For information about using the embedded JDBC version of the FastLoad utility, see ODBC Driver for Teradata® User Guide, B035-2526.
MULTILOAD MultiLoad

For information about using the CLIv2 version of the MultiLoad utility, see Teradata® MultiLoad Reference, B035-2409.
TPTEXP Teradata Parallel Transporter EXPORT operator (FastExport emulation)

For information about the Teradata Parallel Transporter Export operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.
TPTLOAD Teradata Parallel Transporter LOAD operator (FastLoad emulation)

For information about the Teradata Parallel Transporter Load operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.
TPTUPD Teradata Parallel Transporter UPDATE operator (MultiLoad emulation)

For information about the Teradata Parallel Transporter Update operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.