15.00 - SET RESOURCE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SET RESOURCE

Purpose  

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

Syntax  

 

Syntax element …

Specifies …

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 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  

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