Correcting DBC.DataBaseSpace and DBC.DBase Values - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

As a result of very rare types of system failures, you might need to correct inconsistencies in the system tables DBC.DataBaseSpace and DBC.DBase. Use the Update DBC and Update Space utilities only when you need to perform these tasks.

Utility Description
Update DBC Recalculates the maximum allowed values for permanent, temporary, and spool space and uses those values to update the DBC.DBase system table and the DBC.DataBaseSpace system table.
Update Space Examines the storage descriptors and recalculates the current usage of space used by:
  • A single database and its individual tables
  • All databases in a system and their individual tables
Values in DBC.DBase are global values. Values in DBC.DataBaseSpace are local AMP values, that is, the global value divided by the number of AMPs in the system.

For instructions on each utility, see Teradata Vantage™ - Database Utilities, B035-1102. For descriptions of the system tables and the views that access them, see Teradata Vantage™ - Data Dictionary, B035-1092.