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 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.