16.20 - GlobalDBSpaceV[X] - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.