Validate Queries Using Query Level Monitoring | Teradata Vantage - 2.2 - Validating Queries Using Query Level Monitoring - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

You can check the QLM query log to validate queries are running on ML Engine.

  1. From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as a user that has SELECT on td_mle_db.querylog. For example:
    .logon systemname.your_company.com/rose
  2. Count the number of queries stored in the QLM log. Run:
    select count(*) from td_mle_db.querylog;

    The result should be non-zero.

  3. Log off:
    .logoff
PostrequisiteIf you created a test user (such as rose), remove the user. For example:
.logon systemname.your_company.com/dbc
delete user rose;
drop user rose;
.logoff