DBW - Advanced SQL Engine - Teradata Database

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. For more information, see 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 }