O'Reilly logo

Teradata Database Administration – Teradata Internals by Tom Coffing, Todd Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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…’”

Isaac Asimov

 

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required