Category: Accounting
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| 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) | The name of a database or one of the following 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. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of a table or join index. |
| MaxPerm | BIGINT | --,---,---,---,---,---,--9 | 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 | 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 | 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 | This field gives the amount of permanent space per AMP currently being used by the database or table. |
| CurrentSpool | BIGINT | --,---,---,---,---,---,--9 | This field gives the amount of spool space per AMP currently being used by the user. |
| CurrentPersistentSpool | BIGINT | --,---,---,---,---,---,--9 | This field gives the amount of persistent spool space per AMP currently being used by the user. |
| CurrentTemp | BIGINT | --,---,---,---,---,---,--9 | The number of bytes currently used by a temporary table per vproc. |
| PeakPerm | BIGINT | --,---,---,---,---,---,--9 | 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 | 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 | 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 | The peak number of bytes used at one time by a temporary table per vproc. |
| MaxProfileSpool | BIGINT | --,---,---,---,---,---,--9 | 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 | The profile TEMPORARY space limit per AMP for the user if the user is assigned a profile which has a TEMPORARY space setting Otherwise, this column has a null value. |
| AllocatedPerm | BIGINT | --,---,---,---,---,---,--9 | The current total allocation in bytes for permanent and user defined temporary table space. |
| AllocatedSpool | BIGINT | --,---,---,---,---,---,--9 | The current total allocation in bytes for spool and other system defined temporary table space. |
| AllocatedTemp | BIGINT | --,---,---,---,---,---,--9 | The current total allocation in bytes for temporary tables space. |
| PermSkew | SMALLINT | ---,--9 | The permissible skew limit percent for permanent space usage at the AMP level. |
| SpoolSkew | SMALLINT | ---,--9 | The permissible skew limit percent for spool space usage at the AMP level. |
| TempSkew | SMALLINT | ---,--9 | The permissible skew limit percent for temporary space usage at the AMP level. |