15.10 - DBW - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty
For instructions on starting the Database Window, see “Database Window (xdbw)” in Utilities.

To enable RSS logging from DBW:

  1. Open the Supvr window.
  2. 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.
  3. Specify the table you want to enable logging to using the database command below.

    where tablename is the suffix part of ResUsageXxxx. 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.