Corresponding Table
- DBC.AccessRights
- DBC.DBase
- DBC.Owners
- DBC.RoleGrants
- DBC.Roles
Types of Events and Fields
The EventsV[X] view returns a row for each archive or recovery operation. The types of event rows are:
| Type of event row … | A row is created for each … |
|---|---|
| Checkpoint | journal checkpointed. |
| Delete | journal deleted. |
| Dump | database or table dumped. |
| Restore | database or table restored. |
| Rollback | database or table rolled back. |
| Rollforward | database or table rolled forward. |
The EventsV[X] view contains the following standard and optional fields. Optional fields can return NULL. Standard fields are not nullable and always return a value.
| Standard Fields | Optional Fields |
|---|---|
| EventNum | DataSetName |
| CreateDate | TableName |
| CreateTime | CheckpointName |
| UserName | LinkingEventNum |
| EventType | LockMode |
| DatabaseName | JournalUsed |
| ObjectType | JournalSaved |
| AllAMPsFlag | IndexPresent |
| RestartSeqNum | DupeDumpSet |
| OperationInProcess |
CreateDate and CreateTime
The CreateDate and CreateTime columns are updated by the PE on which the session is running. That is, all events for a given session are timestamp-ordered.
However, if multiple or concurrent sessions are running on different PEs, any discrepancy in AMP clocks may be reflected in the timestamp sequence. This may also occur if a Teradata Database is connected to more than one client system and the client system clocks are not synchronized.
Possible Values for AllAMPsFlag
| Value | Description |
|---|---|
| A | ALL AMPS USED |
| C | ALL CLUSTERS |
| P | ALL PROCESSORS |
Possible Values for EventType
- CHECKPOINT
- RESTORE
- DELETE
- ROLLBACK
- DUMP
- ROLLFORWARD
Possible Values for ObjectType
| Value | Description |
|---|---|
| D | Database |
| J | Journal Table |
| Q | Backup or restore of selected partitions |
| T | Table |
Possible Values for OperationInProcess
| Value | Description |
|---|---|
| Y | Indicates an event is still processing. |
| N | Event is not processing. |
TableName
If the object is a database, the TableName column is set to NULL.