Category: Operations
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| CreateDate | DATE NOT NULL | YYYY/MM/DD | The date when the event took place. |
| CreateTime | FLOAT NOT NULL | 99:99:99.99 | The time when the event took place. |
| EventNum | INTEGER NOT NULL | --,---,---,--9 | The client system event number of the restore operation. |
| EventType | CHAR(30) LATIN NOT CASESPECIFIC NOT NULL | X(30) | Type of event that occurred. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The username associated with the event. |
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the database in which the event occurred. |
| ObjectType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Indicates the level of object that was specified for the event.This is a D is for database level, T for table level,Q for Backup or restore of selected partitions or J for journal. |
| AllAmpsFlag | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | A code that indicates whether the event was run on all AMPs, clusters, or processors. |
| RestartSeqNum | SMALLINT | ---,--9 | Integer (0 through n) to indicate the number of times that the database system had to be restarted during the event. 0 indicates that no restarts took place. |
| OperationInProcess | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | A code to indicate whether the event is still processing. The following codes are used: Y = Yes, N = No. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the table affected by the event. If the object is a database, then the value is set to NULL. |
| CheckPointName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The checkpoint name as specified by the user in the CHECKPOINT statement. |
| LinkingEventNum | INTEGER | --,---,---,--9 | The terminating event number specified by the user for a rollforward or rollbackward event. |
| DataSetName | VARCHAR(44) UNICODE NOT CASESPECIFIC | X(44) | The client system data set name for a dump or restore event. |
| LockMode | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | A code to indicate the type of lock used by the event. The codes are as follows: A = ACCESS or Group READ, R = full READ. |
| JournalUsed | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Specifies one of the following codes to indicate which part of the journal table was used:
|
| JournalSaved | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Specifies one of the following codes to indicate whether the SAVE option was used in the event: Y = Yes, N = No. |
| IndexPresent | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Specifies Y (yes) or N (no) to indicate whether the INDEX option was used in a dump event. |
| DupeDumpSet | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | A code to indicate whether the dump event created a duplicate archive dataset. |