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:
|
| LogChange | Indicator of whether this rate applies to the ResLogging or 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