Collecting Useful DBQL Historical Data - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Collecting Useful DBQL Historical Data

DBQL History summaries key DBQL data to 1 row per user / account / application ID / client ID per time period. Teradata recommends retaining 13 months of copied detail. That is, Teradata recommends copying detail to another table daily. You should delete the source of copied detail daily to keep online summary collection efficient.