15.00 - 15.10 - How to Control Logging of ResUsage Data - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Several mechanisms exist within Teradata Database for setting the logging rates of ResUsage data. The control sets allow users to do any of the following:

  • Specify data logging rate.
  • Enable or disable ResUsage data logging on a table-by-table basis.
  • Enable or disable summarization of the data.
  • Enable or disable active row filtering.
  • Logging rates control the frequency that resource usage data is logged to the ResUsage tables.

    You can use the SET LOGTABLE command to establish the logging of resource usage information. The system inserts data into ResUsage tables every logging period for the tables that have logging enabled. You can use the statistics collected in the ResUsage tables to analyze system bottlenecks, determine excessive swapping, and detect system load imbalances.