Work with the Query Log - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities

With Teradata Administrator, log SQL queries that the system processes.

Use the following procedure for query logging.

1 From the main window, click Tools > Query Logging.

2 Define the attributes and options as indicated in Table 33.

3 Use the buttons on the dialog box as follows:

  • Begin Log – starts query logging for the selected user.
  • Note: In Teradata Database version 13.10 and later you do not need to use the End Log command before issuing a new Begin Log command for the same criteria.

  • End Log – stops query logging for the selected user.
  • Display – displays the query logging rules for the selected user.
  • Delete – deletes all existing rules for the selected user.
  • 4 Click Close when finished.