Setting Query Logging Rules - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Database Query Log (DBQL) stores historical records of queries, together with their duration, performance, and target activity, based on rules you define.
  1. In the Data Source Explorer, right-click a database or user, and click Teradata > Logging > Query Logging The Query Logging Rules dialog opens.
  2. On the Set Query Logging tab, specify the criteria for the query logging you want Teradata Database to record. You can log queries issued by a specific application, one or more users or databases, or one or more database accounts. Query logging rules can specify what to log (such as object names, SQL text, EXPLAIN text), and you can set parameters to limit the logging and save space.
  3. Click Begin Log to create your query logging rule and begin logging. A QueryLogging Rules message confirms that the logging rule was created successfully.
  4. Click OK. Query logging using the new rule begins.