15.00 - DBQL CPU/IO Collection - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DBQL CPU/IO Collection

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 SQL Data Definition Language.

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. This is the default.

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.

Default

1

Changes Take Effect

After the DBS Control Record has been written.