Usage Notes - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

A query band is a set of name and value pairs that can be set on a session to identify where a query originated. These identifiers are in addition to the current set of session identification fields, such as user id, account string, client id, and application name. Query bands offer a way to identify the user and application, for example, when SQL-generating tools and web applications use pooling mechanisms that hide the identity of users because each connection in the pool logs into the database using the same user account. Without query bands, there is no way to tell the source of the request when the request comes from a multitiered application. Another potential use of query bands is troubleshooting, when it is necessary to provide the specific user, application, or report that issued a request.

All SET QUERY_BAND statements submitted by Teradata ARC are session query bands. A session query band is stored in a session table and recovered after a system reset. Teradata ARC does not use transaction query bands.