17.00 - 17.05 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
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');