15.10 - EventsV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

CreateDate

DATE

NOT NULL

YY/MM/DD (explicit)

RCEvent.CreateDate

CreateTime

TIME

NOT NULL

99:99:99.99 (explicit)

RCEvent.CreateTime

EventNum

INTEGER

NOT NULL

--,---,---,--9 (explicit)

RCEvent.EventNum (NUPI)

EventType

CHAR(30) LATIN

NOT CASESPECIFIC

NOT NULL

X(30)

RCEvent.EventType

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

RCEvent.UserName

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

RCEvent.DatabaseName

ObjectType

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.ObjectType

AllAMPsFlag

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

RCEvent.AllAMPsFlag

RestartSeqNum

SMALLINT

---,--9 (explicit)

RCEvent.RestartSeqNum

OperationInProcess

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

RCEvent.OperationInProces

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

RCEvent.TableName

CheckpointName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

RCEvent.CheckpointName

LinkingEventNum

INTEGER

--,---,---,--9 (explicit)

RCEvent.LinkingEventNum

DataSetName

VARCHAR(44)

UNICODE

NOT CASESPECIFIC

X(44)

RCEvent.DataSetName

LockMode

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.LockMode

JournalUsed

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.JournalUsed

JournalSaved

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.JournalSaved

IndexPresent

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.IndexPresent

DupeDumpSet

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

RCEvent.DupeDumpSet

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • 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.

    The following SELECT statement selects information associated with the requesting user from the DBC.EventsX view:

    ==> SELECT CreateDate, CreateTime, EventType, JournalUsed FROM DBC.EventsV;

    Result:

    CreateDate   ­CreateTime   ­EventType     ­JournalUsed
    ----------   ----------   -----------   -----------
    87/03/18     11:10:45     Rollforward   R
    87/03/18     11:18:20     Restore       R
    87/03/19     12:06:34     Rollforward   R
    87/02/12     14:13:38     Dump          S