Using the Update Space Utility - 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™
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
The Update Space utility accomplishes this by:
  • Examining storage descriptors and adding up space for each table.
  • Setting values in CurrentPermSpace, CurrentTempSpace, or CurrentSpoolSpace in the DBC.DatabaseSpace table for each table and for the containing database as a whole.

A different utility, Update DBC (updatedbc), recalculates the maximum allowed values for permanent, temporary, and spool space in the DBC.Dbase and DBC.DatabaseSpace tables.

The following are the difference between the Update DBC and Update Space utilities:
  • Update DBC recalculates maximum allowed values for permanent, temporary, and spool space.
  • Update Space recalculates current usage for permanent, temporary, and spool space.

The only reason to use Update Space is to correct inconsistencies in the DBC.DatabaseSpace table, which might occur as the result of rare types of system failures.

The format of the command to use with the “Update Space” utility is:

UPDATE {
  { TEMPORARY | ALL } SPACE FOR { ALL DATABASES | dbname | ALL PROXYUSERS } |
  { SPOOL | PSPOOL } SPACE FOR { dbname | ALL PROXYUSERS }
} [;]

If the problem is fixed using Update Space, then the problem was phantom spool. If running Update Space does not fix the problem, you have leftover spool and the only way to fix the problem is to restart the system.

For assistance with spool space problems, contact Teradata Support.

Related Information

Topic Resources for Further Information
Command syntax for the Update Space utility "Update Space" (updatespace)" in Teradata Vantage™ - Database Utilities, B035-1102
The spool space problems Knowledge Article SD1000C126E
DBC.DatabaseSpace table Teradata Vantage™ - Data Dictionary, B035-1092