17.10 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The following example returns the consumed data space in terabytes for the system:

EXEC SystemFE.CDS_System('N');
Use CDS_AddExclusion/CDS_AddExclusion_ANSI and CDS_ViewExclusions/CDS_ViewExclusions_ANSI to add to and view a list of objects to be excluded from data space computations. By default, some Data Dictionary tables are already in the exclusion list.

The following example collects summary statistics on the objects in the system if they are stale or not already collected, to return a more accurate estimate of CDS size:

EXEC systemfe.CDS_System('Y');