MarkAutoDBAObjects Example - 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

This example marks all existing tables within the SalesDb database as being under fully autonomous control.

CALL TDStats.MarkAutoDbaObjects('{"DatabaseName":"SalesDb","AutoDBA":"F","Cascade":"true"}',jOut);

Result:

jOut
---------------------------------------------------------------------------------------------------------------------------------------------------------
{"NumDatabasesMarked":1,"NumTablesMarked":2,"NumMarkingErrors":0,"Errors":null}