15.10 - Events_MediaV[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

DataSetName

VARCHAR(44)

UNICODE

NOT CASESPECIFIC

X(44)

RCEvent.DataSetName

VolSerialId

CHAR(6) LATIN

NOT CASESPECIFIC

NOT NULL

X(6)

RCMedia.VolSerialId

VolSequenceNum

SMALLINT

---,--9 (explicit)

RCMedia.VolSequenceNum

DupeDumpSet

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

RCMedia.DupeDumpSet

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
  • In this example, the requesting user is researching the Events_Media view for events associated with the user named ‘PAL’.

    ==> SELECT DataSetName,VolSerialId,DupeDumpSet
           FROM DBC.Events_MediaV WHERE UserName = 'PAL' ;

    Result:

    DataSetName      ­VolSerialId     ­DupeDumpSet
    -------------    -----------     -----------
    BRM.DBC.TEXT1    000469          N
    BRM.DBC.TEXT1    000469          N
    BRM.DBC.TEXT2    000469          N
    BRM.DBC.TEXT2    000469          N
    BRM.DBC.TEXT1    BRM001          Y
    BRM.DBC.TEXT1    BRM002          Y
    BRM.DBC.TEXT2    BRM001          N
    BRM.DBC.TEXT2    BRM002          N