16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Corresponding Table

The X view references these additional tables:
  • 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.