MarkAutoDBAObjects 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.MarkAutoDBAObjects(
   IN jIn JSON(3000) CHARACTER SET UNICODE,
   OUT jOut JSON(3000) CHARACTER SET UNICODE)
   SQL SECURITY INVOKER

JSON Keys

JSON Key IN/OUT Data Type Description
DatabaseName IN VARCHAR Name of database to mark.
TableName IN VARCHAR Name of table to mark. If NULL, all tables within DatabaseName are marked.
ObjectListName IN VARCHAR List of objects to mark. See related API "CreateObjectList" in ObjectList APIs Syntax.
AutoDBA IN CHAR Marking option:
  • 'F' - Fully-autonomous
  • 'S' - Semi-autonomous (with check)
  • 'N' - No AutoDBA control
Cascade IN BOOLEAN
  • 'true' - Cascade specified AutoDBA option to existing child objects.
  • 'false' - Do not cascade to child objects.

Default value is false.
NumDatabasesMarked OUT INTEGER Number of databases successfully marked.
NumTablesMarked OUT INTEGER Number of tables successfully marked.
NumMarkingErrors OUT INTEGER Number of databases and tables left unmarked due to errors.
Errors OUT INTEGER Keys [QualifiedObjectName, SQL_Code] indicating the object marking failed along with error code.