PreserveAfterRecreate 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.PreserveAfterRecreateJSON(
  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) Identifies the database whose AutoStats tuning metadata should be marked for preservation.
TableName IN VARCHAR(128) Identifies a particular table within DatabaseName on which to mark for preservation.
ObjectListName IN VARCHAR(128) Specifies a previously defined list of objects on which to mark for preservation. See related API "CreateObjectList" in ObjectList APIs Syntax.
NumPreserved OUT INTEGER Number of statistic entries/definitions marked for preservation.