SET RESOURCE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

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

Syntax

SET RESOURCE {
  { COLLECTION | COLL } seconds [ { LOGGING | LOG } seconds ] |
 
  { LOGGING | LOG } seconds [ { COLLECTION | COLL } seconds ]
}

Syntax Elements

COLLECTION seconds
COLL seconds
the interval between PMPC interface requests for RSS data.
Valid values are 0 - 3600 seconds.
LOGGING seconds
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 Teradata Vantage™ - Application Programming Reference, B035-1090.

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 Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.

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