You can enable the resource usage tables using the Control GDO Editor (ctl) utility or the database commands in Database Window (DBW).
Before you enable the resource usage tables, determine which tables apply to the resource usage macros you want to run. For more information, see Teradata Vantage™ Resource Usage Macros and Tables, B035-1099.
You can set various Teradata Database configuration settings using ctl. The RSS screen in ctl allows you to specify the rates of resource usage data logging. For detailed information on starting ctl and modifying the settings, see "ctl" in Teradata Vantage™ - Database Utilities , B035-1102 .
To enable RSS logging from DBW
- Open the Supvr window.
- Set the Node Logging Rate using the database command below.
where number is the number of seconds.A rate of zero disables the logging function.
- Specify the table you want to enable logging to using the database command
where tablename is the suffix part of ResUsage Xxxx. For example, for the DBC.ResUsageSpma table, the tablename would be “Spma.”
After the table is enabled for logging, you can log rows in Summary Mode.To log rows in Summary Mode, you must enable the table specified in both the RSS Table Logging Enable group and in the RSS Summary Mode Enable group.
- (Optional) Enable Summary Mode on the table specified using the command below.
Example of Enabling Table Logging and Setting the Logging Rate
The following example shows you how to enable table logging and set the Logging rate using the database commands in DBW. Suppose you want to enable the ResUsageShst table and set the logging rate for 10 minutes (600 seconds). You would enter the following:
set logtable shst on set resource log 600