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

GET RESOURCE

Purpose  

Returns the RSS collection and logging rates for the ResUsage tables.

Syntax  

Usage Notes  

The collection period is used to extract the data for real-time tools to display and the logging period is used for writing the data to the database.

The default for PMPC Resource Collection Rate, Node Logging Rate is 600. A logging or collection rate of 0 disables that operation.

For details about logging rate of resource utilization, see Resource Usage Macros and Tables.

Note: You can also view the current logging and collection rates by issuing the SCREEN RSS command in the Control GDO Editor (ctl) utility. For more information, see Chapter 7: “Control GDO Editor (ctl).”

Example  

The following example shows the RSS collection and logging rates for the ResUsage tables on the current system.

get resource
 
RSS Rate Information:
      PMPC Resource Collection Rate = 600
      Node Logging Rate   = 600