The Database Query Log (DBQL) stores historical records of queries, together with their duration, performance, and target activity, based on rules you define.
- In the Data Source Explorer, right-click a database or user, and click The Query Logging Rules dialog opens.
- 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.
- Click Begin Log to create your query logging rule and begin logging. A QueryLogging Rules message confirms that the logging rule was created successfully.
- Click OK. Query logging using the new rule begins.