Enable RSS Logging | Teradata Vantage - Enabling RSS Logging - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

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

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 following database command.
    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 following database command.
    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 following command.
    SET SUMLOGTABLE tablename { ON | OFF }

Example of Enabling Table Logging and Setting the Logging Rate

The following example shows 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