UpdateStatThresholdSetting Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

API Definition

REPLACE PROCEDURE tdstats.UpdateStatThresholdSettingJSON
  (IN jIn JSON(3000) CHARACTER SET UNICODE,
   OUT jOut JSON(3000) CHARACTER SET UNICODE)

JSON Keys

JSON Key IN/OUT Data Type Description
SCOID IN BIGINT AutoStats assigned identifier of an individual statistic whose settings are to be changed.
DatabaseName IN VARCHAR(128) Apply the new settings to all statistics collected within the specified database.
TableName IN VARCHAR(128) Apply the new settings to an individual table residing within the specified DatabaseName.
ThresholdType IN CHAR(1) Type to use for THRESHOLD option for generated COLLECT STATISTICS statements.
Valid values are:
  • 'S' - Designates SYSTEM THRESHOLD
  • 'U’- Designates THRESHOLD <AgeThreshold> DAYS AND THRESHOLD <GrowthThreshold> PERCENT
  • 'N' - Designates NO THRESHOLD
AgeThreshold IN INTEGER Value for <AgeThreshold> in number of days.

Allowable values are 1 to 9999.
GrowthThreshold IN INTEGER Value for <GrowthThreshold> as a percentage.
ForCurrentOnly IN BOOLEAN
  • true - The THRESHOLD setting will be issued along with the FOR CURRENT option making it applicable to the current collection only.
  • false or NULL - The THRESHOLD setting is applied to all future collections.
NumUpdated OUT INTEGER Number of statistics whose histogram settings have been updated.