The Update DBC utility, updatedbc, performs the following:
| In table … | Update DBC recalculates … |
|---|---|
| DBASE | PermSpace, SpoolSpace, and TempSpace values for user DBC.
For databases other than DBC, the PermSpace, SpoolSpace, and TempSpace values in the DBASE table are the maximums declared when the database is defined. The DBASE table includes the following columns:
|
| DATABASESPACE | MaxPermSpace, MaxSpoolSpace, and MaxTempSpace values for each database in the system based on the PermSpace, SpoolSpace, and TempSpace values in the DBASE table for that database. The DATABASESPACE table includes the following columns:
|
Values in the DBASE table are the global values. Values in the DATABASESPACE table are local AMP values. The calculation is the global value divided by the number of AMPs in the system.
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 DBC only to correct inconsistency in the DBASE or DATABASESPACE tables, 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 Space utility, see Update Space (updatespace).