SetResourceRate Syntax - Teradata Vantage

REPLACE FUNCTION SYSLIB.SetResourceRate (
  SampleRate INTEGER,
  LogChange VARCHAR(1),
  VprocChange VARCHAR(1)
) RETURNS INTEGER
  ...
;

Syntax Elements

SampleRate

Value of the collection rate. This field is used either to collect resource data or to log resource data to the resource usage tables.

You can specify one of the following:

• The ResMonitor rate value if you want to change the resource monitoring rate.
• The ResLogging rate value if you want to change the resource logging rate.

  The value must be an integral divisor of 3600.

• Zero to turn off the resource collection or logging.

LogChange

Indicator of whether this rate applies to the ResLogging or ResMonitor rate:

• Y or y = ResLogging rate
• N, n, NULL, or blank = ResMonitor rate

VprocChange

This field is obsolete.