RemoveMissingRecs 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 Description

REPLACE PROCEDURE TDStats.RemoveMissingRecsJSON(
    IN jIn JSON(3000) CHARACTER SET UNICODE,
    OUT jOut JSON(3000) CHARACTER SET UNICODE)

JSON Keys

JSON Key IN/OUT Data Type Description
DatabaseName IN VARCHAR(128) Erase all recommendations on the specified database.
ObjectName IN VARCHAR(128) Further limit the erasing to the statistics defined on a specified table of DatabaseName.
ObjectListName IN VARCHAR(128) Specifies a previously defined list of objects whose recommendations should be erased. See related API "CreateObjectList" in ObjectList APIs Syntax.
AnalysisID IN BOOLEAN Erase recommendations from a prior call to an Analysis API whose results are marked with the specified AutoStats assigned identifier.
OlderThan IN STRING Erase recommendations older than a specified timestamp.
NumRemoved OUT INTEGER Number of recommendations that were erased.