16.10 - GET RESOURCE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.

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