Advanced SQL Engine | Utilities | Update Space (updatespace) | Teradata Vantage - 17.10 - Update Space (updatespace) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
The utility described is not available for as-a-service customers.
The Update Space utility, updatespace, recalculates the permanent, temporary, or spool space used by either of the following:
  • A single database and its individual tables
  • All databases in a system and their individual tables
Update Space accomplishes this by performing the following:
  • Examining storage descriptors and adding up space for each table.
  • Setting values in CurrentPermSpace, CurrentTempSpace, or CurrentSpoolSpace in the DATABASESPACE table for each table and for the containing database as a whole.

The following table lists the difference between the Update DBC and Update Space utilities.

The utility … Recalculates the …
Update DBC maximum allowed values for permanent, temporary, and spool space.
Update Space current usage for permanent, temporary, and spool space.

Use Update Space only to correct inconsistency in the DATABASESPACE table, which might occur as the result of rare types of system failures.

For descriptions of the DBASE and DATABASESPACE tables and columns, see Teradata Vantage™ - Data Dictionary, B035-1092.

For more information on the Update DBC utility, see Update DBC (updatedbc)