17.10 - MaxSetQueryBandSize - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

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

Defines the maximum query band size in kilobytes that can be set with the SET QUERY_BAND statement.

Field Group

General

Valid Range

2 - 4 KB

Default

3 KB

Changes Take Effect

When the DBS Control record is written. Changes are effective for new sessions that begin after the change.

Usage Notes

HELP SESSION displays several fields relating to query bands: QueryBand, Transaction QueryBand, Session QueryBand, and Profile QueryBand. The QueryBand field concatenates the values of Transaction QueryBand and Session QueryBand fields. Setting MaxSetQueryBandSize to a value greater than 2 KB can result in truncation of the concatenated QueryBand field in the output of HELP SESSION. To find the full concatenated query band string for the current transaction, session, and profile, use the GetQueryBand function.

Related Information

  • For more information about query bands, see Teradata Vantage™ - Database Administration, B035-1093 and Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
  • For more information about the GetQueryBand function, see Teradata Vantage™ - Application Programming Reference, B035-1090.