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