Corresponding Tables
The X view references these additional tables:
- DBC.AccessRights
- DBC.DBase
- DBC.Owners
- DBC.RoleGrants
- DBC.Roles
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 EventType
- CHECKPOINT
- RESTORE
- DELETE
- ROLLBACK
- DUMP
- ROLLFORWARD