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 DBC utility, updatedbc, performs the following:

In table … Update DBC recalculates …
DBASE PermSpace, SpoolSpace, and TempSpace values for user DBC.
  • The PermSpace value in DBASE for user DBC is the total available storage space minus the PermSpace for all other databases.
  • The SpoolSpace and TempSpace values in DBASE for user DBC are the total available storage space.

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:

  • PermSpace
  • SpoolSpace
  • TempSpace
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:

  • CurrentPermSpace
  • CurrentSpoolSpace
  • CurrentTempSpace
  • MaxPermSpace
  • MaxSpoolSpace
  • MaxTempSpace

Values in the DBASE table are the global values. Values in the DATABASESPACE table are local AMP values. The calculation is the global value divideded 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 Data Dictionary.

For more information on the Update Space utility, see Update Space (updatespace).