17.00 - GlobalDBSpaceV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Accounting

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a database or one of the special system keywords: ALL / DEFAULT / PUBLIC.
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.
MaxPerm BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the maximum allocation in bytes for permanent and user defined temporary table space.
MaxSpool BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the maximum allocation in bytes for spool and system defined temporary table space.
MaxTemp BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the maximum allocation in bytes for temporary table space.
AllocatedPerm BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the current total allocation in bytes for permanent and user defined temporary table space.
AllocatedSpool BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the current total allocation in bytes for spool and other system defined temporary table space.
AllocatedTemp BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the current total allocation in bytes for temporary tables space.
PeakAllocatedPerm BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the peak permanent space allocated in the database/user across the system since the last initialize.
PeakAllocatedSpool BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the peak spool space allocated to the user across the system since the last initialize.
PeakAllocatedTemp BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the peak temporary space allocated to the user across the system since the last initialize.
MaxProfileSpool BIGINT --,---,---,---,---,---,--9 Returns the profile SPOOL space limit for the user if the user is assigned a profile which has a SPOOL space setting. Otherwise, this column has a null value.
MaxProfileTemp BIGINT --,---,---,---,---,---,--9 Returns the profile TEMP space limit for the user if the user is assigned a profile which has a TEMP space setting. Otherwise, this column has a null value.
PermSkew SMALLINT ---,--9 Returns the permissible skew limit percent for permanent space usage at the AMP level.
SpoolSkew SMALLINT ---,--9 Returns the permissible skew limit percent for spool space usage at the AMP level.
TempSkew SMALLINT ---,--9 Returns the permissible skew limit percent for temporary space usage at the AMP level.
SpaceMapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the contiguous space map name of the database/user.