17.10 - Query Bands and Load Utilities - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

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.