16.10 - SET RESOURCE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Changes the rates at which the resource sampling subsystem (RSS) data is requested by applications such as PMPC and ResUsage.

Syntax



COLLECTION seconds or COLL seconds
the interval between PMPC interface requests for RSS data.
Valid values are 0 - 3600 seconds.
LOGGING seconds or LOG seconds
how frequently ResUsage writes statistics to the database.
Valid values are 0 - 3600 seconds.
A setting of 0 means RSS data is not logged.

Usage Notes

The PMPC Resource Collection Rate is the rate at which the RSS data will be requested by the PM/API application. This affects applications that use the PM/API to display system performance information, such as Teradata Viewpoint. For more information on the PM/API, see Application Programming Reference.

The Node Logging Rate is the rate at which RSS data is logged to the enabled ResUsage tables in the database.

RSS aligns the logging periods to the clock on the top of every hour. Therefore, these values must divide evenly into 3600 seconds (one hour). The following set of values are legal for RSS logging rates: 0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 12, 15, 16, 18, 20, 24, 25, 30, 36, 40, 45, 48, 50, 60, 72, 75, 80, 90, 100, 120, 144, 150, 180, 200, 225, 240, 300, 360, 400, 450, 600, 720, 900, 1200, 1800, 3600.

The SET RESOURCE command is effective immediately.

For details about logging, see Resource Usage Macros and Tables.

Example: Setting the resource collection and logging rates

The current RSS Rate Information is as follows:

RSS Rate Information:
     PMPC Resource Collection Rate =    30
     Node Logging Rate   =   600

In this example, the Collection Rate is set to 600, and the Node Logging Rate is set to 1200.

set resource collection 600 logging 1200

RSS rates set.
     PMPC Resource Collection Rate =   600
     Node Logging Rate   =   1200