16.10 - MaxSetQueryBandSize - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
vkz1472241255652

Purpose

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 Topics

  • For more information about query bands, see Database Administration and SQL Data Definition Language - Syntax and Examples.
  • For more information about the GetQueryBand function, see Application Programming Reference.