17.10 - DBQL CPU/IO Collection - 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)

Sets the algorithm used by DBQL to collect CPU and input/output statistics.

DBQL CPU/IO collection captures performance data for the execution of a query at the request level and, optionally, at the step level. It includes several options for specifying the data that is collected. See also the information about the BEGIN QUERY LOGGING statement in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

Field Group

General

Valid Settings

Setting Description
0 Indicates DBQL CPU/IO Collection has not yet been explicitly set. In this case, DBQL uses the default collection algorithm.
1 DBQL uses Algorithm 1, the classic algorithm with step adjustments.
2 DBQL uses AMP Algorithm 2. For most situations, this algorithm provides improved collection over Algorithm 1. Algorithm 2 is used primarily for certain types of diagnostic analysis.
3 DBQL uses Algorithm 3. Captures data for aborted and parallel steps, step instances for iterative steps, and includes additional information and status about step and request execution over Algorithms 1 and 2. This is the default.

Default

3

Changes Take Effect

After the DBS Control Record has been written.