17.10 - GET RESOURCE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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