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