16.10 - Overview - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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 Data Dictionary.

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