Teradata Query Banding - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
Teradata Warehouse Miner utilizes the Query Banding feature introduced in Teradata 12.0. This feature provides a mechanism for applications to associate metadata with Teradata queries that may be useful for various Teradata utilities in identifying, managing and accounting for those queries. Teradata Warehouse Miner utilizes Query Banding only when it executes an analysis or project, not when performing maintenance functions or metadata queries and not inside any stored procedures that may be generated by the product. Query Banding is also not performed when executing an analytic algorithm, algorithm scoring or matrix building analysis.
Query Banding is performed even when an analysis is marked “Generate-SQL-Only”.

Teradata Warehouse Miner sets certain query band name-value pairs at the SESSION level, not at the TRANSACTION level. These name-value pairs include:

ClientUser=<logon userid>
ApplicationName=TWM
Version=<TWM version>
Source=<Project Name>

For example, when user twm executes project Test Project using TWM 05.03.03, the query band is set internally using the following command:

SET QUERY_BAND =
'ClientUser=twm;ApplicationName=TWM;Version=05.03.03;Source=Test Project;'
 FOR SESSION;