Example - Advanced SQL Engine - Teradata Database

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kak1592015099875.ditamap
dita:ditavalPath
kak1592015099875.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢

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');