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.
- LOGGING seconds
- LOG seconds
- how frequently ResUsage writes statistics to the database.
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