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. |