Vantage mechanisms enable you to do the following:
- Specify ResUsage data logging rate (frequency that data is logged to ResUsage tables).
- 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.
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. Use the statistics in the ResUsage tables to analyze system bottlenecks, determine excessive swapping, and detect system load imbalances.