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).