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

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

Syntax

GET RESOURCE

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

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 Control GDO Editor (ctl).

Example: Displaying the current RSS collection and logging rates

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