SetResourceRate Function | Application Programming Reference | Teradata Vantage - 17.05 - SetResourceRate - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Purpose

Sets either the ResMonitor or ResLogging rate.

Definition

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

Input Parameters

Parameter Description
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 should 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.

Usage Notes - SetResourceRate

The SetResourceRate function provides similar functionality to the PMPC SET RESOURCE RATE request. For information about this interface and the ResMonitor and ResLogging rates, see SET RESOURCE RATE.

Return Value

This function returns the previous collection rate value in seconds.

Example: Using SetResourceRate

This example uses SetResourceRate to set the ResMonitor rate.

SELECT SetResourceRate(60, 'N', 'N');
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 5 seconds.
SetResourceRate(60,'N','N')
---------------------------
                        600