17.05 - DBW - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
For instructions on starting the Database Window, see “Database Window (xdbw)” in Teradata Vantage™ - Database Utilities , B035-1102 .

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 }