DiskSpaceV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Accounting

Database: DBC

View Column Data Type Format Comment
Vproc INTEGER NOT NULL --,---,---,--9 Identifies the virtual processor for which an event was logged.
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 --,---,---,---,---,---,--9 Returns an integer that represents the maximum permanent space, in bytes, that is allocated to the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
MaxSpool BIGINT --,---,---,---,---,---,--9 Returns an integer that represents the maximum spool space, in bytes, that is allocated to the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
MaxTemp BIGINT --,---,---,---,---,---,--9 Returns an integer that represents the maximum temporary space, in bytes, that is allocated to the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
CurrentPerm BIGINT --,---,---,---,---,---,--9 Returns the permanent space (in bytes) currently used by the database or table.
CurrentSpool BIGINT --,---,---,---,---,---,--9 Returns the spool space (in bytes) currently used by the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
CurrentPersistentSpool BIGINT --,---,---,---,---,---,--9 Returns the persistent spool space (in bytes) currently used by the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
CurrentTemp BIGINT --,---,---,---,---,---,--9 Returns the number of bytes currently used by a temporary table per vproc.
PeakPerm BIGINT --,---,---,---,---,---,--9 Returns the maximum amount of permanent space per AMP that has been used by the database since the last time the DBC.ClearPeakDisk macro was run.
PeakSpool BIGINT --,---,---,---,---,---,--9 Returns an integer that represents the maximum spool space, in bytes, that was used at any one time by the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
PeakPersistentSpool BIGINT --,---,---,---,---,---,--9 Returns an integer that represents the maximum persistent spool space, in bytes, that was used at any one time by the database on a specified AMP (or on all AMPs if the SUM aggregate is specified).
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 per AMP 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 TEMPORARY space limit per AMP for the user if the user is assigned a profile which has a.
AllocatedPerm BIGINT --,---,---,---,---,---,--9 Returns the current allocation in bytes for permanent and user defined temporary table space on the AMP.
AllocatedSpool BIGINT --,---,---,---,---,---,--9 Returns the current allocation in bytes for spool and other system-defined temporary table space on the AMP.
AllocatedTemp BIGINT --,---,---,---,---,---,--9 Returns the current allocation in bytes for temporary tables space on the AMP.
PermSkew SMALLINT ---,--9 Returns the permissible skew limit percent for permanent space usage at the Global level.
SpoolSkew SMALLINT ---,--9 Returns the permissible skew limit percent for spool space usage at the Global level.
TempSkew SMALLINT ---,--9 Returns the permissible skew limit percent for temporary space usage at the Global level.