Work with the Query Log - Teradata Administrator

Work with the Query Log

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

Use the following procedure for query logging.

To work with the query log

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.