Save DBQL Log Data | Teradata Vantage - 17.10 - Saving DBQL Log Data - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-171K
Language
English (United States)
The DBQLRuleTbl and DBQLRuleCountTbl are archived and restored only if database DBC is migrated. To migrate data from other DBQL tables, the data from these tables must first be copied into a user database/table. For more information about saving DBQL log data, see Teradata Vantageā„¢ - Database Administration, B035-1093.
Definitions of the DBQL log tables often change between major releases, and the data in DBQL log tables from a prior release does not get converted to match the data collected using the definitions in the subsequent release.

All of the DBQL rules that were present on the source system are save/restored, so the same information is collected on the destination system.

Teradata Professional Services can set up standard DBQL rules and logging on the destination system.

The dbql_out.rpt file, output by the pre-processing script, details how many rows exist in each of the DBQL tables. The table below shows an example.
Table Count
DBQLExplainTbl 152478
DBQLObjTbl 3078221
DBQLogTbl 219991
DBQLSqlTbl 220024
DBQLStepTbl 1073967
DBQLSummaryTbl 0