Category: Database
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of a database or one of the special system keywords: ALL / DEFAULT / PUBLIC. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The user who issued the CREATE DATABASE statement. |
| OwnerName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Database owner name. |
| AccountName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Expanded account in effect when a request was submitted. |
| ProtectionType | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies F (Fallback) or N (None) to indicate whether the tables in the database are protected by the Fallback option. |
| JournalFlag | CHAR(2) LATIN UPPERCASE NOT NULL | X(2) | Journaling in effect for the table, or the journal default for tables. Settings: first character BEFORE, second character AFTER. |
| PermSpace | BIGINT NOT NULL | --,---,---,---,---,---,--9 | Integer indicating the total space allocated to the database on all AMPs. |
| SpoolSpace | BIGINT NOT NULL | --,---,---,---,---,---,--9 | Integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC. |
| TempSpace | BIGINT NOT NULL | --,---,---,---,---,---,--9 | Maximum temporary space allocated for a database, profile, or user in bytes. |
| CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | User-supplied text or commentary on the column, database, table, view, macro, user-defined function, stored procedure, role, profile, or user. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time the dictionary row was last updated. |
| DBKind | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Contains information that indicates whether the row information represents a database (D) or a user (U). |
| AccessCount | BIGINT | --,---,---,---,---,---,--9 | Access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time that the corresponding object was last accessed. |
| DefaultMapName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Default map name for the database or user. NULL indicates the database or user does not have a default map. |
| MapOverride | VARCHAR(1) LATIN NOT CASESPECIFIC | X(1) | Indicates no override or override on error for the default map. "N" indicates no override. "E" indicates OVERRIDE ON ERROR. |
| IncrementalRestoreEnabled | INTEGER | --,---,---,--9 | Indicates if Incremental Restore has been enabled for the database. |
| DefaultComputeGroup | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The default compute cluster group for the database or user. NULL indicates the database or user does not have a default compute cluster group. |
| DefaultStorageName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The default storage name for the database or user. NULL indicates the database or user does not have a default storage. |
| StorageOverride | CHAR(1) LATIN UPPERCASE | X(1) | Indicates no override or override on error for the default storage. "N" indicates no override. "E" indicates OVERRIDE ON ERROR. |
| AutoDBA | CHAR(1) | X(1) |
|
| AutoDBABits | BYTE(40) | X(80) | AutoDBA bits when the database is under AutoDBA control. Null when the database is under AutoDBA control. |