DBQL CPU/IO Collection - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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. For more information, see "BEGIN QUERY LOGGING" 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.