17.00 - AllGlobalSpaceV[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.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The TableName field identifies a table within a database.
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.
CurrentPerm BIGINT --,---,---,---,---,---,--9 Returns the maximum used in bytes for permanent and user defined temporary table space.
CurrentSpool BIGINT --,---,---,---,---,---,--9 Returns the maximum used in bytes for spool and user defined temporary table space.
CurrentPersistentSpool BIGINT --,---,---,---,---,---,--9 Returns the persistent spool space in bytes currently in use.
CurrentTemp BIGINT --,---,---,---,---,---,--9 Returns the maximum used in bytes for temporary table space.
PeakPerm BIGINT --,---,---,---,---,---,--9 The peak number of bytes of permanent space allocated for a given user/database across system since the time the field was last initialized.
PeakSpool BIGINT --,---,---,---,---,---,--9 The peak number of bytes of spool space allocated to the user across the system since the time the field was last initialized.
PeakPersistentSpool BIGINT --,---,---,---,---,---,--9 The peak number of bytes of temporary space allocated to a given user across the system since the time the field was last initialized.
PeakTemp BIGINT --,---,---,---,---,---,--9 Returns the peak number of bytes used at one time by a temporary table per vproc.
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.
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.
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.