Enable RSS Logging | Teradata Vantage - Enabling RSS Logging - Advanced SQL Engine - Teradata Database

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.

ctl

You can set various 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.

DBW

To enable RSS logging from DBW

1. Open the Supvr window.
2. Set the Node Logging Rate using the database command below.

   SET RESOURCE { LOGGING | LOG } number

   where number is the number of seconds.

   A rate of zero disables the logging function.
3. Specify the table you want to enable logging to using the database command below.

   SET LOGTABLE { tablename | ALL } { ON | OFF }

   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.
4. (Optional) Enable Summary Mode on the table specified using the command below.

   SET SUMLOGTABLE tablename { ON | OFF }

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