Chapter 12 – DBQL Query Logging
“The most exciting phrase to hear in science, the one that heralds the most discoveries, is not ‘Eureka!’, but ‘That’s funny…’”
DBQL Query Logging
The Database Query Log (DBQL) (starting with Teradata V2R5) allows you to log certain queries or all queries so they can be analyzed later.
This allows you to enhance your Teradata indexes and design because you now have an idea on what queries are being run on the system.
The DBA must be granted permission to utilize DBQL and then the DBA can begin or end collection for a specific user, a specific account, or group of users or a list of accounts.
You can use the Nexus to see all queries stored in DBQL.
The DBA must perform a BEGIN LOGGING for any ...