Example: CDS_System Macro - Teradata Vantage - Analytics Database

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
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');