Query Bands and Load Utilities - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

The term load utilities include utilities or applications that use the Teradata FastLoad, MultiLoad, and FastExport protocols such as the Teradata Parallel Transport Load, Update, and Export operator, the FastLoad, MultiLoad, and FastExport utilities, and the embedded JDBC versions of FastExport and FastLoad.

You can classify these utilities based on session query bands. Because a transaction query band is discarded when a transaction ends, you should set a session query band when you use query banding with the data loading utilities if the query band is to be applied to all statements in the utility script.

Client load utilities can set several optional reserved query band names to control throttling. Vantage receives information about the name of the utility and the size of the data through these reserved query band names.

For example, a client utility can set the UtilityDataSize query band by means of a script. This sizing information is then used by Vantage as an aid in determining the number of AMP sessions to use for the load job.

The expected values for UtilityDataSize are SMALL, MEDIUM, and LARGE. These values provide Vantage with a simple way to influence the selection of the number of sessions needed to process the load job. The intent is to select a reasonable number of sessions for the default. You can use session configuration rules to provide a more precise selection.

Note that the client utilities do not set the UtilityDataSize query band automatically. To make use of UtilityDataSize, you must specify it in a script like the one in the following example.

.LOGTABLE Logtable002;
.LOGON tdpx/user,pwd;

 SET QUERY_BAND='UtilityDataSize=LARGE;' UPDATE FOR SESSION;

.BEGIN IMPORT MLOAD TABLES Employee;
..........
.END MLOAD;
.LOGOFF;

See Reserved Query Band Names and Values for a list of reserved query band names and values for the load utilities and to the appropriate Teradata Tools and Utilities documentation for more information about client utilities.