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

LogProcessor

SMALLINT

-(5)9

RCConfiguration.LogProcessor

PhyProcessor

SMALLINT

ZZZZ9 (explicit)

RCConfiguration.PhyProcessor

Vproc

SMALLINT

-(5)9

RCConfiguration.Vproc

ProcessorState

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

RCConfiguration.ProcessorState

RestartSeqNum

SMALLINT

---,--9 (explicit)

RCConfiguration.RestartSeqNum

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • The Events_ConfigurationV[X] view contains rows for each archive activity that does not affect all AMPs in the Teradata Database 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.

    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
  • The statement on the following screen selects information concerning the requesting user from the DBC.Events_ConfigurationX view:

    ==> SELECT CreateDate, CreateTime, EventNum, EventType
           FROM DBC.Events_ConfigurationV;

    Result:

    CreateDate   ­CreateTime   ­EventNum   ­EventType
    ----------   ----------   --------   ------------
    87/03/18     08:53:48          30    Rollforward
    87/03/18     08:57:49          44    Rollforward
    87/03/18     08:54:42          33    Rollforward
    87/03/20     11:26:26          98    Dump
    87/03/18     09:00:05          52    Rollforward
    87/03/18     09:30:59          55    Restore
    87/03/18     08:57:02          41    Rollforward