17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The Events_ConfigurationV[X] view contains rows for each archive activity that does not affect all AMPs in the system configuration.

If the activity is for all AMPs and there are AMPs off-line, a row is inserted for each off-line AMP. If the activity is for specific AMPs, a row is inserted for each AMP that is specified and online.

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