Teradata Query Banding

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
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;